Overview

Dataset statistics

Number of variables65
Number of observations1121
Missing cells20789
Missing cells (%)28.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.9 MiB
Average record size in memory3.6 KiB

Variable types

CAT50
NUM10
BOOL3
UNSUPPORTED1
URL1

Reproduction

Analysis started2022-11-01 01:42:00.760781
Analysis finished2022-11-01 01:42:27.841817
Duration27.08 seconds
Versionpandas-profiling v2.7.1
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
type_of_disaster has constant value "Hurricane" Constant
_project has constant value "CMMI-1761461" Constant
fulcrum_id has a high cardinality: 1121 distinct values High cardinality
general_notes has a high cardinality: 127 distinct values High cardinality
photos has a high cardinality: 1120 distinct values High cardinality
building_address_sub_thoroughfare has a high cardinality: 835 distinct values High cardinality
building_address_thoroughfare has a high cardinality: 357 distinct values High cardinality
building_address_locality has a high cardinality: 52 distinct values High cardinality
building_address_full has a high cardinality: 1101 distinct values High cardinality
other_details has a high cardinality: 99 distinct values High cardinality
other_structural_details has a high cardinality: 73 distinct values High cardinality
damage_description has a high cardinality: 344 distinct values High cardinality
qc_notes has a high cardinality: 919 distinct values High cardinality
effective_year_built is highly correlated with year_builtHigh correlation
year_built is highly correlated with effective_year_builtHigh correlation
general_notes has 992 (88.5%) missing values Missing
photos_caption has 35 (3.1%) missing values Missing
building_address_suite has 1066 (95.1%) missing values Missing
building_address_country has 29 (2.6%) missing values Missing
assessment_type has 40 (3.6%) missing values Missing
assessment_type_other has 1081 (96.4%) missing values Missing
year_built has 81 (7.2%) missing values Missing
effective_year_built has 145 (12.9%) missing values Missing
number_of_stories has 57 (5.1%) missing values Missing
roof_shape has 53 (4.7%) missing values Missing
roof_shape_other has 1111 (99.1%) missing values Missing
roof_cover has 136 (12.1%) missing values Missing
roof_cover_other has 1046 (93.3%) missing values Missing
wall_cladding has 90 (8.0%) missing values Missing
wall_cladding_other has 1081 (96.4%) missing values Missing
other_details has 1017 (90.7%) missing values Missing
structural_framing_system has 89 (7.9%) missing values Missing
structural_framing_system_other has 1099 (98.0%) missing values Missing
roof_sheathing_nail_spacing has 1110 (99.0%) missing values Missing
roof_sheathing_nail_size_other has 1120 (99.9%) missing values Missing
roof_to_wall_connection has 631 (56.3%) missing values Missing
roof_to_wall_connection_other has 1121 (100.0%) missing values Missing
opening_protection has 285 (25.4%) missing values Missing
opening_protection_other has 1056 (94.2%) missing values Missing
garage_door has 95 (8.5%) missing values Missing
garage_door_location has 1002 (89.4%) missing values Missing
garage_door_failure has 770 (68.7%) missing values Missing
other_structural_details has 1040 (92.8%) missing values Missing
damage_modes has 149 (13.3%) missing values Missing
damage_modes_other has 1113 (99.3%) missing values Missing
number_of_sides_used has 86 (7.7%) missing values Missing
damage_visible_in_photos has 79 (7.0%) missing values Missing
damage_description has 678 (60.5%) missing values Missing
water_height_inches has 1064 (94.9%) missing values Missing
structure_usable has 54 (4.8%) missing values Missing
qc_notes has 48 (4.3%) missing values Missing
year_built is highly skewed (γ1 = -28.25839657) Skewed
effective_year_built is highly skewed (γ1 = -27.79443758) Skewed
fulcrum_id is uniformly distributed Uniform
general_notes is uniformly distributed Uniform
photos is uniformly distributed Uniform
building_address_suite is uniformly distributed Uniform
building_address_full is uniformly distributed Uniform
other_details is uniformly distributed Uniform
other_structural_details is uniformly distributed Uniform
fulcrum_id has unique values Unique
roof_to_wall_connection_other is an unsupported type, check if it needs cleaning or further analysis Unsupported
overall_building_condition has 196 (17.5%) zeros Zeros
first_floor_elevation_ft has 513 (45.8%) zeros Zeros

Variables

fulcrum_id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE
Distinct count1121
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
32c1b935-d086-4d5d-8f23-2bd154ee20ec
 
1
570bf794-4f46-42d7-a1f6-b837542e6893
 
1
638497a4-5e6a-4642-96a1-79ad383994dd
 
1
94be4887-e026-4108-a067-87b3ff52326f
 
1
2fe82398-d5c1-4e3e-bc22-60eba2d6015c
 
1
Other values (1116)
1116
ValueCountFrequency (%) 
32c1b935-d086-4d5d-8f23-2bd154ee20ec 1 0.1%
 
570bf794-4f46-42d7-a1f6-b837542e6893 1 0.1%
 
638497a4-5e6a-4642-96a1-79ad383994dd 1 0.1%
 
94be4887-e026-4108-a067-87b3ff52326f 1 0.1%
 
2fe82398-d5c1-4e3e-bc22-60eba2d6015c 1 0.1%
 
87ca20ec-5860-4c11-9c5c-49ddb809c9b7 1 0.1%
 
f5a928e2-506a-4f90-ba94-03e08795f606 1 0.1%
 
05e1da84-5463-4df4-a497-6c9867b1bdc8 1 0.1%
 
f695043a-61a4-45c1-a7ba-028ba0cc9281 1 0.1%
 
efde4816-653e-4891-a9e6-b888c45e98a2 1 0.1%
 
Other values (1111) 1111 99.1%
 

Length

Max length36
Mean length36
Min length36
ValueCountFrequency (%) 
Decimal_Number 10 58.8%
 
Lowercase_Letter 6 35.3%
 
Dash_Punctuation 1 5.9%
 
ValueCountFrequency (%) 
Common 11 64.7%
 
Latin 6 35.3%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 

latitude
Real number (ℝ≥0)

Distinct count1092
Unique (%)97.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.507950154799286
Minimum24.553088
Maximum30.01545947
Zeros0
Zeros (%)0.0%
Memory size8.9 KiB

Quantile statistics

Minimum24.553088
5-th percentile24.62562831
Q124.672029
median25.809741
Q325.953294
95-th percentile26.17857
Maximum30.01545947
Range5.46237147
Interquartile range (IQR)1.281265

Descriptive statistics

Standard deviation1.117350394
Coefficient of variation (CV)0.04380400569
Kurtosis7.144334435
Mean25.50795015
Median Absolute Deviation (MAD)1.02111
Skewness2.380072911
Sum28594.41212
Variance1.248471902
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
24.654928 4 0.4%
 
24.65532 3 0.3%
 
24.656112 3 0.3%
 
24.660932 2 0.2%
 
24.677913 2 0.2%
 
24.660915 2 0.2%
 
24.726729 2 0.2%
 
24.727006 2 0.2%
 
25.949719 2 0.2%
 
24.655325 2 0.2%
 
Other values (1082) 1097 97.9%
 
ValueCountFrequency (%) 
24.553088 1 0.1%
 
24.566691 1 0.1%
 
24.567435 1 0.1%
 
24.568201 1 0.1%
 
24.568206 1 0.1%
 
ValueCountFrequency (%) 
30.01545947 1 0.1%
 
30.01505 1 0.1%
 
30.014873 1 0.1%
 
30.014699 1 0.1%
 
30.014469 1 0.1%
 

longitude
Real number (ℝ)

Distinct count1093
Unique (%)97.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-81.44529188086528
Minimum-81.87274471
Maximum-80.0335956
Zeros0
Zeros (%)0.0%
Memory size8.9 KiB

Quantile statistics

Minimum-81.87274471
5-th percentile-81.729641
Q1-81.71397
median-81.40977
Q3-81.363024
95-th percentile-80.88812929
Maximum-80.0335956
Range1.83914911
Interquartile range (IQR)0.350946

Descriptive statistics

Standard deviation0.295710113
Coefficient of variation (CV)-0.003630782162
Kurtosis4.283420978
Mean-81.44529188
Median Absolute Deviation (MAD)0.191448
Skewness1.756083456
Sum-91300.1722
Variance0.0874444709
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
-81.385195 3 0.3%
 
-81.728888 3 0.3%
 
-81.385217 3 0.3%
 
-81.601202 2 0.2%
 
-81.71625 2 0.2%
 
-81.385847 2 0.2%
 
-81.699249 2 0.2%
 
-81.716051 2 0.2%
 
-81.388146 2 0.2%
 
-81.730084 2 0.2%
 
Other values (1083) 1098 97.9%
 
ValueCountFrequency (%) 
-81.87274471 1 0.1%
 
-81.810663 1 0.1%
 
-81.805015 1 0.1%
 
-81.80484186 1 0.1%
 
-81.79862 1 0.1%
 
ValueCountFrequency (%) 
-80.0335956 1 0.1%
 
-80.12752 1 0.1%
 
-80.131579 1 0.1%
 
-80.132527 1 0.1%
 
-80.18625 1 0.1%
 

name_of_surveyor
Categorical

Distinct count26
Unique (%)2.3%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Sarah Stevenson
133
Shiling Pei
 
103
Maryam Refan
 
79
Zheyu He
 
76
Glenn Overcash
 
72
Other values (21)
658
ValueCountFrequency (%) 
Sarah Stevenson 133 11.9%
 
Shiling Pei 103 9.2%
 
Maryam Refan 79 7.0%
 
Zheyu He 76 6.8%
 
Glenn Overcash 72 6.4%
 
Fred Haan 70 6.2%
 
Mohammad Moravej 66 5.9%
 
Jason M. Lopez 58 5.2%
 
Daniel Smith 57 5.1%
 
Jean-Paul Pinelli 49 4.4%
 
Other values (16) 358 31.9%
 

Length

Max length24
Mean length13.1293488
Min length8
ValueCountFrequency (%) 
Lowercase_Letter 24 49.0%
 
Uppercase_Letter 22 44.9%
 
Space_Separator 1 2.0%
 
Other_Punctuation 1 2.0%
 
Dash_Punctuation 1 2.0%
 
ValueCountFrequency (%) 
Latin 46 93.9%
 
Common 3 6.1%
 
ValueCountFrequency (%) 
ASCII 49 100.0%
 

date_of_survey
Categorical

Distinct count20
Unique (%)1.8%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
9/16/2017
240
9/23/2017
184
9/17/2017
183
9/24/2017
146
9/19/2017
98
Other values (15)
270
ValueCountFrequency (%) 
9/16/2017 240 21.4%
 
9/23/2017 184 16.4%
 
9/17/2017 183 16.3%
 
9/24/2017 146 13.0%
 
9/19/2017 98 8.7%
 
9/12/2017 63 5.6%
 
9/20/2017 49 4.4%
 
9/13/2017 36 3.2%
 
12/11/2017 19 1.7%
 
9/25/2017 18 1.6%
 
Other values (10) 85 7.6%
 

Length

Max length10
Mean length9.064228368
Min length9
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

type_of_disaster
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Hurricane
1121
ValueCountFrequency (%) 
Hurricane 1121 100.0%
 

Length

Max length9
Mean length9
Min length9
ValueCountFrequency (%) 
Lowercase_Letter 7 87.5%
 
Uppercase_Letter 1 12.5%
 
ValueCountFrequency (%) 
Latin 8 100.0%
 
ValueCountFrequency (%) 
ASCII 8 100.0%
 

_project
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
CMMI-1761461
1121
ValueCountFrequency (%) 
CMMI-1761461 1121 100.0%
 

Length

Max length12
Mean length12
Min length12
ValueCountFrequency (%) 
Decimal_Number 4 50.0%
 
Uppercase_Letter 3 37.5%
 
Dash_Punctuation 1 12.5%
 
ValueCountFrequency (%) 
Common 5 62.5%
 
Latin 3 37.5%
 
ValueCountFrequency (%) 
ASCII 8 100.0%
 

general_notes
Categorical

HIGH CARDINALITY
MISSING
UNIFORM
Distinct count127
Unique (%)98.4%
Missing992
Missing (%)88.5%
Memory size8.9 KiB
Enchanting shores coop park - MH
 
2
Cyclone-induced tornado
 
2
Roof lost. According to 22973 construction was late 90?€?s.
 
1
Temporary structure (gazebo) in front of the house was destroyed, roof of the back porch was destroyed,
 
1
Island Montessori School where aluminum soffit failure around metal sided mansard roof failed leading to pressurization and water damage.
 
1
Other values (122)
122
ValueCountFrequency (%) 
Enchanting shores coop park - MH 2 0.2%
 
Cyclone-induced tornado 2 0.2%
 
Roof lost. According to 22973 construction was late 90?€?s. 1 0.1%
 
Temporary structure (gazebo) in front of the house was destroyed, roof of the back porch was destroyed, 1 0.1%
 
Island Montessori School where aluminum soffit failure around metal sided mansard roof failed leading to pressurization and water damage. 1 0.1%
 
Tile roof damage 1 0.1%
 
Roof damage - site visited by pre-MAT 1 0.1%
 
Modular elevated waterfront home. Siding and soffit damage but no damage according to homeowner. Shutters performed well. Siding and shingles replaced in 2014 1 0.1%
 
New unit According to park manager - appears to have performed well despite attached carport. 1 0.1%
 
Owner didn't allow us in but part of the roof was completly blown away. 1 0.1%
 
Other values (117) 117 10.4%
 
(Missing) 992 88.5%
 

Length

Max length558
Mean length11.06155219
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 26 34.7%
 
Uppercase_Letter 22 29.3%
 
Decimal_Number 10 13.3%
 
Other_Punctuation 9 12.0%
 
Control 2 2.7%
 
Currency_Symbol 1 1.3%
 
Math_Symbol 1 1.3%
 
Open_Punctuation 1 1.3%
 
Dash_Punctuation 1 1.3%
 
Close_Punctuation 1 1.3%
 
ValueCountFrequency (%) 
Latin 48 64.0%
 
Common 27 36.0%
 
ValueCountFrequency (%) 
ASCII 74 100.0%
 

photos
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count1120
Unique (%)100.0%
Missing1
Missing (%)0.1%
Memory size8.9 KiB
5373b0f4-2911-4b32-b53f-907f48c2f1db,e1a55e54-e1aa-44be-994a-17dfeb2aa642,1958d78f-37a8-4eff-91f9-177f58a94537,a43b8513-7c36-490d-af34-18d5f55a0f4f,eb3d4ef9-daf4-4ad1-b428-c7543b4b9dbc,8bb67872-5f06-41c0-a65d-65ffafe637af
 
1
fba4da79-d18e-46a4-8793-16e7b18d67bf,90bea214-79aa-4d08-9233-a33a822ac8a0
 
1
02c29b0e-30e2-4238-a21b-440994f0913b,9f6033b9-ec69-49d5-8c7e-9cd06da0e860,12bfd08c-62f8-4800-875f-261699ac2f1c
 
1
9f44f26d-be77-41a2-8596-0f5878e31f9b,abf64474-92b9-4155-8da7-6a59d34c20cc,e1e71515-da5e-4dea-a32b-01bf80821c7a,3e0fba7d-96b1-4a4e-a7ae-d3b7c014150a,42e370df-3115-45d2-a8b8-c687ff2d8cac,a4b480da-6aa0-4f38-bebe-8354cf906ae0,b6bdcd13-b6f1-4e4b-9351-3068a1b8e985,11ddad52-c058-45c3-a06e-90634c814544,90a3da13-3c2e-4aa4-982b-1904735d1c05,6955dfe6-fa31-4e7d-8938-a2b044afa42a,316895fe-b348-47db-8d2d-46b53a3d8809,ed100e60-d677-4e1a-97f7-a0cf1ff47a2e,00d8a1f6-86ab-4fc4-aecd-e6f533c08411,fa7afb2b-3774-4e1f-b8ca-921ab60bd946,b59aaa32-f942-468a-a224-65667389c2ef,f932d0f7-e870-461c-a56e-ff57bdd64ca8,aa908ed5-416d-409b-9440-e8ad534c87e9,105307b0-df7a-416b-9144-128ef64c072d,3b6c6c08-4e42-427f-a451-c38c05766335,27524f08-1833-4320-86fb-43417b7f605d,e41c003b-e9b8-40a9-b25a-1f26f93f9233,b8f4faa6-6446-42bd-9ab3-eae9e0febb61,32652956-67e2-4961-91c7-2632eb7bc8da,c96a7ba7-5f81-4711-96b6-3c65210b0a32,c006d177-9dd4-4f70-b386-3b11deb88447,e59f8b4c-fdaf-4cee-972e-224d0dfc6282,91c09dcc-a0bb-477f-804b-d59b83493fa5,4c437a2d-a880-4aea-9f6a-b6b887a08092,d4d07985-9816-418c-bad1-7c387405de78,34ee6790-6f95-4697-a1fc-8ad2d1392f67,07af348f-7691-46eb-a60b-fade0451c178
 
1
2f11eec3-6c42-4285-99c7-3e3708445d3c,902fe10a-fdfb-4df3-92ac-b81d51d1c0eb
 
1
Other values (1115)
1115
ValueCountFrequency (%) 
5373b0f4-2911-4b32-b53f-907f48c2f1db,e1a55e54-e1aa-44be-994a-17dfeb2aa642,1958d78f-37a8-4eff-91f9-177f58a94537,a43b8513-7c36-490d-af34-18d5f55a0f4f,eb3d4ef9-daf4-4ad1-b428-c7543b4b9dbc,8bb67872-5f06-41c0-a65d-65ffafe637af 1 0.1%
 
fba4da79-d18e-46a4-8793-16e7b18d67bf,90bea214-79aa-4d08-9233-a33a822ac8a0 1 0.1%
 
02c29b0e-30e2-4238-a21b-440994f0913b,9f6033b9-ec69-49d5-8c7e-9cd06da0e860,12bfd08c-62f8-4800-875f-261699ac2f1c 1 0.1%
 
9f44f26d-be77-41a2-8596-0f5878e31f9b,abf64474-92b9-4155-8da7-6a59d34c20cc,e1e71515-da5e-4dea-a32b-01bf80821c7a,3e0fba7d-96b1-4a4e-a7ae-d3b7c014150a,42e370df-3115-45d2-a8b8-c687ff2d8cac,a4b480da-6aa0-4f38-bebe-8354cf906ae0,b6bdcd13-b6f1-4e4b-9351-3068a1b8e985,11ddad52-c058-45c3-a06e-90634c814544,90a3da13-3c2e-4aa4-982b-1904735d1c05,6955dfe6-fa31-4e7d-8938-a2b044afa42a,316895fe-b348-47db-8d2d-46b53a3d8809,ed100e60-d677-4e1a-97f7-a0cf1ff47a2e,00d8a1f6-86ab-4fc4-aecd-e6f533c08411,fa7afb2b-3774-4e1f-b8ca-921ab60bd946,b59aaa32-f942-468a-a224-65667389c2ef,f932d0f7-e870-461c-a56e-ff57bdd64ca8,aa908ed5-416d-409b-9440-e8ad534c87e9,105307b0-df7a-416b-9144-128ef64c072d,3b6c6c08-4e42-427f-a451-c38c05766335,27524f08-1833-4320-86fb-43417b7f605d,e41c003b-e9b8-40a9-b25a-1f26f93f9233,b8f4faa6-6446-42bd-9ab3-eae9e0febb61,32652956-67e2-4961-91c7-2632eb7bc8da,c96a7ba7-5f81-4711-96b6-3c65210b0a32,c006d177-9dd4-4f70-b386-3b11deb88447,e59f8b4c-fdaf-4cee-972e-224d0dfc6282,91c09dcc-a0bb-477f-804b-d59b83493fa5,4c437a2d-a880-4aea-9f6a-b6b887a08092,d4d07985-9816-418c-bad1-7c387405de78,34ee6790-6f95-4697-a1fc-8ad2d1392f67,07af348f-7691-46eb-a60b-fade0451c178 1 0.1%
 
2f11eec3-6c42-4285-99c7-3e3708445d3c,902fe10a-fdfb-4df3-92ac-b81d51d1c0eb 1 0.1%
 
ca603e9a-927b-4bce-a87d-508d1b36df75,79d3e6d6-58fa-427d-b799-df0bdba69809,bfd51ce0-c257-4bf7-996d-e1814509d859 1 0.1%
 
7f443256-2ad8-457e-8614-6ce5d48f42a3,041a5554-5677-481e-aa00-97c8946a0166,87a3a1a8-c5a5-4b33-aaec-34b69d1678ae 1 0.1%
 
9db28099-4c32-4094-8a72-e7a978cfcd4a,526413b5-7e07-4d5f-a1de-0b70dfcb2f19 1 0.1%
 
26c3f76a-b8e2-4963-ac73-8c3ad921a7da,fdc346c5-79fc-4d6e-9a1f-1123c0f6d031,2a747c62-73c4-4976-8415-f14af86b2d02 1 0.1%
 
68207ea8-81b6-415d-9981-a076280a318c,7069e325-3f59-4730-a979-38436e871102,67802aa2-5396-44d3-ac06-33fa5d40686c 1 0.1%
 
Other values (1110) 1110 99.0%
 

Length

Max length2700
Mean length155.7832293
Min length3
ValueCountFrequency (%) 
Decimal_Number 10 52.6%
 
Lowercase_Letter 7 36.8%
 
Dash_Punctuation 1 5.3%
 
Other_Punctuation 1 5.3%
 
ValueCountFrequency (%) 
Common 12 63.2%
 
Latin 7 36.8%
 
ValueCountFrequency (%) 
ASCII 19 100.0%
 

photos_caption
Categorical

MISSING
Distinct count22
Unique (%)2.0%
Missing35
Missing (%)3.1%
Memory size8.9 KiB
,,
286
,
267
,,,
193
,,,,
104
,,,,,
75
Other values (17)
161
ValueCountFrequency (%) 
,, 286 25.5%
 
, 267 23.8%
 
,,, 193 17.2%
 
,,,, 104 9.3%
 
,,,,, 75 6.7%
 
,,,,,, 50 4.5%
 
,,,,,,, 32 2.9%
 
,,,,,,,, 20 1.8%
 
,,,,,,,,, 15 1.3%
 
,,,,,,,,,,, 11 1.0%
 
Other values (12) 33 2.9%
 
(Missing) 35 3.1%
 

Length

Max length72
Mean length3.40499554
Min length1
ValueCountFrequency (%) 
Lowercase_Letter 18 69.2%
 
Uppercase_Letter 5 19.2%
 
Other_Punctuation 2 7.7%
 
Space_Separator 1 3.8%
 
ValueCountFrequency (%) 
Latin 23 88.5%
 
Common 3 11.5%
 
ValueCountFrequency (%) 
ASCII 26 100.0%
 
Distinct count1120
Unique (%)100.0%
Missing1
Missing (%)0.1%
Memory size8.9 KiB
https://web.fulcrumapp.com/photos/view?photos=4e04fc8e-8a18-48dd-9cbf-415f0e8e1dd7%2Cf6c190ef-0155-40b2-9645-30fc00894875%2C8158585b-a62f-4768-b02b-6bff1ee42e94%2C2aee37b3-5922-419c-be04-f13b6dbdb9ab
 
1
https://web.fulcrumapp.com/photos/view?photos=0270d4f5-1629-494d-8256-1b90b89f70e6%2C801addd2-e30f-4c43-a591-0488a8e5f142
 
1
https://web.fulcrumapp.com/photos/view?photos=1b5acd91-9efc-4e6f-bb38-26528a7539e6%2C83d08691-8a1a-4a67-9d67-0344268219ad%2C7634572f-46d1-4718-8e74-b7ff49f8e803%2Cdc246c20-788d-484c-aa76-7566187ac9df
 
1
https://web.fulcrumapp.com/photos/view?photos=3b0e99f0-a0d2-47da-a266-5bf7b79db0d4%2C088ece4e-e8b8-4098-a0d0-afe39afba19e
 
1
https://web.fulcrumapp.com/photos/view?photos=b59247a3-edc2-41ca-bc3b-3132bf43e6b5%2Cdd6db5b6-ce50-41e3-af76-d681608c1a3a%2Cd6ea6dbd-d107-47ba-b514-2ef62565985c
 
1
Other values (1115)
1115
ValueCountFrequency (%) 
https://web.fulcrumapp.com/photos/view?photos=4e04fc8e-8a18-48dd-9cbf-415f0e8e1dd7%2Cf6c190ef-0155-40b2-9645-30fc00894875%2C8158585b-a62f-4768-b02b-6bff1ee42e94%2C2aee37b3-5922-419c-be04-f13b6dbdb9ab 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=0270d4f5-1629-494d-8256-1b90b89f70e6%2C801addd2-e30f-4c43-a591-0488a8e5f142 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=1b5acd91-9efc-4e6f-bb38-26528a7539e6%2C83d08691-8a1a-4a67-9d67-0344268219ad%2C7634572f-46d1-4718-8e74-b7ff49f8e803%2Cdc246c20-788d-484c-aa76-7566187ac9df 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=3b0e99f0-a0d2-47da-a266-5bf7b79db0d4%2C088ece4e-e8b8-4098-a0d0-afe39afba19e 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=b59247a3-edc2-41ca-bc3b-3132bf43e6b5%2Cdd6db5b6-ce50-41e3-af76-d681608c1a3a%2Cd6ea6dbd-d107-47ba-b514-2ef62565985c 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=082093f1-1557-4ea8-957c-d6f078fce6db%2C7c251701-ec5a-44e6-8ede-046abb1fae04%2C0d82d32e-0fc6-452c-9579-34855cd0af6e%2C857de4d4-b9e2-4b0a-b391-ced1e07db8e4%2Cfe3156ec-bc4c-4522-86a5-837faa162864%2Cec795a63-09fd-4ca9-a355-e676c0aa9e19 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=ac6b8b2c-0195-4eb8-9aac-6df4a2dfdd42%2C98134f00-cb7e-4480-b8b2-fc9181e0ed6b%2Cebe3647d-15c6-478a-8514-ae76070332ec%2Cb71fc963-88c2-4690-bedb-ecfb1f6cac88%2C40ce9343-eca8-41ac-8a86-fec054e03d87%2Cbabb2cf7-eecf-4463-b8bb-612ea35bb1a9%2C7471ca16-947a-4ca9-a914-e2f8b5bb5bac%2C68b230c1-2554-42d7-8039-d697979525c9 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=4a23e3b8-2f3e-42be-a6ed-6f24705752a6%2Cd9633b9a-85c1-4237-a564-5748e6ec0db1%2Cc037e1a1-2ce7-4639-8af2-ce366b0b15b6%2Cbf993f27-0ab1-47b6-8d28-70930e8064fd%2C1de059a3-3e14-4dce-91aa-1eecc963da38%2C8473edfe-5b67-4ef6-be38-9fcb4b92607b%2C6517c646-facf-4f53-8d9b-a7758fadc4b1 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=6b3d09c9-9465-4ef9-b44c-0bd0a5d63530%2Cb4ee7b4a-0370-45d3-af53-9658dacb1082%2C3f2460d7-8570-4a66-83ee-b0a0ad47b2fc%2C7764d564-be5e-48b8-878f-83dfc87ebed1%2C3979d48e-513d-4a07-8087-00491e80d81c%2Cf45e8fe2-18b4-4aa7-a103-5004ee981cc4%2C0b41a410-ff46-4dcc-844f-7dc5f8006a7e%2Cad1d85fd-8b19-4dfc-b0e9-7ac31602c50d%2Cc0180e7d-e2c8-481c-a22c-7471a7b2d2e6%2C28960955-d436-44ed-b0a4-6d4257f05539%2C3a43bd56-0fae-4b44-8fcd-b60f73ca3caa 1 0.1%
 
https://web.fulcrumapp.com/photos/view?photos=e9d58d66-9d14-4201-8c42-2e2b6d65c061%2C63cfcc13-e876-4219-86eb-cf8a22a12ac5%2C114f7f95-a493-4ae1-9e35-4408a18a31b4 1 0.1%
 
Other values (1110) 1110 99.0%
 
ValueCountFrequency (%) 
https 1120 99.9%
 
(Missing) 1 0.1%
 
ValueCountFrequency (%) 
web.fulcrumapp.com 1120 99.9%
 
(Missing) 1 0.1%
 
ValueCountFrequency (%) 
/photos/view 1120 99.9%
 
(Missing) 1 0.1%
 
ValueCountFrequency (%) 
photos=81cc563b-1ade-4ae1-8843-637eafd35ebe%2Ce264e8f7-8f17-4b9e-8220-eccdb57566ae%2C81be6d36-ee3f-4bad-82ff-f0ee08d85c4a 1 0.1%
 
photos=b8594c27-fc28-44f5-a1b2-5fe583b0e430%2C0fa6cfc3-0293-4a58-86b3-66aeab8e4571%2C7cd5861f-321e-45cb-8453-af3802ccd6fc%2C431e57d4-c872-4c82-a8df-7a755b8b25ac%2C92404e50-eff2-41a4-98e8-f34b5d42a1ce 1 0.1%
 
photos=fc84a38b-5455-4c40-b196-884013e1965e%2Cd680b855-cbd9-40ff-ab93-446a9ce2c12e%2C5efad280-2b78-4b40-890f-a006aee692e9%2C2ab4e60c-651a-40a2-ae98-2ea82320a962%2C74522256-f7b4-4702-8e49-990649ce34c2 1 0.1%
 
photos=f7a9cf3c-61fd-4a00-a9fb-1d6eab955caf%2C17b493ca-0a26-4772-bae0-dbf523fc78cf 1 0.1%
 
photos=b68f157f-b83e-4845-bbe1-74f4c16dbdae%2C264076b0-facd-40d0-8114-4348cb47ee63 1 0.1%
 
photos=5b405156-363a-44da-a1bb-c4de16ffd555%2C35caea11-c41c-4f45-afc9-0aad17881971%2Cfd560607-f100-4878-9985-155d2fd51559%2C84eaa32b-7afe-460b-a944-95b1f38360e8 1 0.1%
 
photos=78e4f84c-c217-49e7-b39e-1b71cb7062c8%2C447c2070-8c92-4bb7-8e66-372adf9ed8a3%2Ca9bf9c8d-35ae-4dd3-8c92-b6a36bdfae96%2C277a5d37-8cdd-4029-97c3-9a3b62d4aa6e%2C4ca841e2-154c-4684-a722-cfda8f9e1ee5%2C71213e79-31bb-44ef-be0d-e4b452958464%2Cc8a0bdca-df2b-45ac-98a6-8442f1d92d31 1 0.1%
 
photos=db82ca31-91ad-490f-8276-e4d6ef4533e5%2C65bb80ba-7e78-4683-8941-241e7a0709b4%2Ccf9a3c18-8929-4512-a6ca-56060a8938db%2C68a5ee85-2b1a-498b-86f1-3416797f552a%2C8cc631fa-62b8-4e98-8cea-332333aaa72a 1 0.1%
 
photos=82179e9e-8944-466c-8a30-eeea4d272338%2C03f3fd67-955a-488d-bd37-3c9c129ad44d%2Cdc47447e-8105-432b-97f0-f990dc0d340f 1 0.1%
 
photos=3b392417-94b4-455e-93dd-fb73ab7598a0%2Cdbe9acd5-fe8d-48bb-82ec-d29a62ba4ff3%2C1e856be2-03bd-4fce-b444-9c742757357d%2C631c53ed-7b22-4112-a621-eb39beb47ce7 1 0.1%
 
Other values (1110) 1110 99.0%
 
ValueCountFrequency (%) 
1120 99.9%
 
(Missing) 1 0.1%
 

overall_building_condition
Real number (ℝ≥0)

ZEROS
Distinct count5
Unique (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.511150758251561
Minimum0
Maximum4
Zeros196
Zeros (%)17.5%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median1
Q32
95-th percentile4
Maximum4
Range4
Interquartile range (IQR)1

Descriptive statistics

Standard deviation1.157317795
Coefficient of variation (CV)0.7658519764
Kurtosis-0.2259320897
Mean1.511150758
Median Absolute Deviation (MAD)1
Skewness0.7102920696
Sum1694
Variance1.339384478
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 466 41.6%
 
2 253 22.6%
 
0 196 17.5%
 
4 104 9.3%
 
3 102 9.1%
 
ValueCountFrequency (%) 
0 196 17.5%
 
1 466 41.6%
 
2 253 22.6%
 
3 102 9.1%
 
4 104 9.3%
 
ValueCountFrequency (%) 
4 104 9.3%
 
3 102 9.1%
 
2 253 22.6%
 
1 466 41.6%
 
0 196 17.5%
 

building_address_sub_thoroughfare
Categorical

HIGH CARDINALITY
Distinct count835
Unique (%)75.2%
Missing11
Missing (%)1.0%
Memory size8.9 KiB
1180
 
26
55
 
17
8550
 
7
505
 
6
507
 
5
Other values (830)
1049
ValueCountFrequency (%) 
1180 26 2.3%
 
55 17 1.5%
 
8550 7 0.6%
 
505 6 0.5%
 
507 5 0.4%
 
10 5 0.4%
 
500 5 0.4%
 
760 4 0.4%
 
310 4 0.4%
 
350 4 0.4%
 
Other values (825) 1027 91.6%
 
(Missing) 11 1.0%
 

Length

Max length13
Mean length3.712756467
Min length1
ValueCountFrequency (%) 
Decimal_Number 10 32.3%
 
Lowercase_Letter 9 29.0%
 
Uppercase_Letter 7 22.6%
 
Other_Punctuation 2 6.5%
 
Dash_Punctuation 1 3.2%
 
Control 1 3.2%
 
Space_Separator 1 3.2%
 
ValueCountFrequency (%) 
Latin 16 51.6%
 
Common 15 48.4%
 
ValueCountFrequency (%) 
ASCII 30 100.0%
 

building_address_thoroughfare
Categorical

HIGH CARDINALITY
Distinct count357
Unique (%)32.0%
Missing4
Missing (%)0.4%
Memory size8.9 KiB
S Ponte Vedra Blvd
 
30
Magnolia Ct
 
24
Copeland Ave N
 
24
Chokoloskee Drive
 
24
Overseas Hwy
 
23
Other values (352)
992
ValueCountFrequency (%) 
S Ponte Vedra Blvd 30 2.7%
 
Magnolia Ct 24 2.1%
 
Copeland Ave N 24 2.1%
 
Chokoloskee Drive 24 2.1%
 
Overseas Hwy 23 2.1%
 
South Joy Circle 19 1.7%
 
Coconut Ave 18 1.6%
 
North Storter Avenue 17 1.5%
 
Nassau Road 16 1.4%
 
Boca Chica Rd 15 1.3%
 
Other values (347) 907 80.9%
 

Length

Max length23
Mean length12.09277431
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 25 41.0%
 
Uppercase_Letter 23 37.7%
 
Decimal_Number 10 16.4%
 
Space_Separator 1 1.6%
 
Other_Punctuation 1 1.6%
 
Dash_Punctuation 1 1.6%
 
ValueCountFrequency (%) 
Latin 48 78.7%
 
Common 13 21.3%
 
ValueCountFrequency (%) 
ASCII 61 100.0%
 

building_address_suite
Categorical

MISSING
UNIFORM
Distinct count47
Unique (%)85.5%
Missing1066
Missing (%)95.1%
Memory size8.9 KiB
Summerhouse Condos
 
5
18
 
2
27
 
2
24
 
2
Units #1-4
 
2
Other values (42)
42
ValueCountFrequency (%) 
Summerhouse Condos 5 0.4%
 
18 2 0.2%
 
27 2 0.2%
 
24 2 0.2%
 
Units #1-4 2 0.2%
 
Unit #7 1 0.1%
 
Lot 432 1 0.1%
 
50 1 0.1%
 
Unit #3 1 0.1%
 
B-110, B-111 1 0.1%
 
Other values (37) 37 3.3%
 
(Missing) 1066 95.1%
 

Length

Max length26
Mean length3.203389831
Min length1
ValueCountFrequency (%) 
Lowercase_Letter 17 42.5%
 
Decimal_Number 10 25.0%
 
Uppercase_Letter 8 20.0%
 
Other_Punctuation 3 7.5%
 
Space_Separator 1 2.5%
 
Dash_Punctuation 1 2.5%
 
ValueCountFrequency (%) 
Latin 25 62.5%
 
Common 15 37.5%
 
ValueCountFrequency (%) 
ASCII 40 100.0%
 

building_address_locality
Categorical

HIGH CARDINALITY
Distinct count52
Unique (%)4.6%
Missing2
Missing (%)0.2%
Memory size8.9 KiB
Marco Island
213
Big Pine Key
118
Naples
 
101
Little Torch Key
 
90
Everglades City
 
78
Other values (47)
519
ValueCountFrequency (%) 
Marco Island 213 19.0%
 
Big Pine Key 118 10.5%
 
Naples 101 9.0%
 
Little Torch Key 90 8.0%
 
Everglades City 78 7.0%
 
Goodland 63 5.6%
 
Marathon 61 5.4%
 
Ramrod Key 51 4.5%
 
Cudjoe Key 51 4.5%
 
Key West 35 3.1%
 
Other values (42) 258 23.0%
 

Length

Max length19
Mean length11.22747547
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 22 50.0%
 
Uppercase_Letter 20 45.5%
 
Space_Separator 1 2.3%
 
Other_Punctuation 1 2.3%
 
ValueCountFrequency (%) 
Latin 42 95.5%
 
Common 2 4.5%
 
ValueCountFrequency (%) 
ASCII 44 100.0%
 
Distinct count9
Unique (%)0.8%
Missing2
Missing (%)0.2%
Memory size8.9 KiB
Monroe
542
Collier
502
St. Johns
 
44
Miami-Dade
 
19
Brevard
 
7
Other values (4)
 
5
ValueCountFrequency (%) 
Monroe 542 48.3%
 
Collier 502 44.8%
 
St. Johns 44 3.9%
 
Miami-Dade 19 1.7%
 
Brevard 7 0.6%
 
Lee 2 0.2%
 
Naples 1 0.1%
 
Palm Beach 1 0.1%
 
Okeechobee 1 0.1%
 
(Missing) 2 0.2%
 

Length

Max length10
Mean length6.636039251
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 17 56.7%
 
Uppercase_Letter 10 33.3%
 
Space_Separator 1 3.3%
 
Other_Punctuation 1 3.3%
 
Dash_Punctuation 1 3.3%
 
ValueCountFrequency (%) 
Latin 27 90.0%
 
Common 3 10.0%
 
ValueCountFrequency (%) 
ASCII 30 100.0%
 
Distinct count3
Unique (%)0.3%
Missing4
Missing (%)0.4%
Memory size8.9 KiB
FL
639
Florida
476
Florida
 
2
ValueCountFrequency (%) 
FL 639 57.0%
 
Florida 476 42.5%
 
Florida 2 0.2%
 
(Missing) 4 0.4%
 

Length

Max length8
Mean length4.137377342
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 7 70.0%
 
Uppercase_Letter 2 20.0%
 
Space_Separator 1 10.0%
 
ValueCountFrequency (%) 
Latin 9 90.0%
 
Common 1 10.0%
 
ValueCountFrequency (%) 
ASCII 10 100.0%
 

building_address_postal_code
Real number (ℝ≥0)

Distinct count42
Unique (%)3.8%
Missing8
Missing (%)0.7%
Infinite0
Infinite (%)0.0%
Mean33501.743935309976
Minimum31439.0
Maximum34974.0
Zeros0
Zeros (%)0.0%
Memory size8.9 KiB

Quantile statistics

Minimum31439
5-th percentile33036
Q133042
median33050
Q334140
95-th percentile34145
Maximum34974
Range3535
Interquartile range (IQR)1098

Descriptive statistics

Standard deviation604.7670445
Coefficient of variation (CV)0.01805180786
Kurtosis-1.057291007
Mean33501.74394
Median Absolute Deviation (MAD)95
Skewness-0.184942474
Sum37287441
Variance365743.1781
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
33042 254 22.7%
 
34145 214 19.1%
 
33043 118 10.5%
 
33050 81 7.2%
 
34139 78 7.0%
 
34140 66 5.9%
 
33040 59 5.3%
 
34113 58 5.2%
 
34138 38 3.4%
 
33036 24 2.1%
 
Other values (32) 123 11.0%
 
ValueCountFrequency (%) 
31439 1 0.1%
 
32080 16 1.4%
 
32082 23 2.1%
 
32802 4 0.4%
 
32905 2 0.2%
 
ValueCountFrequency (%) 
34974 1 0.1%
 
34145 214 19.1%
 
34141 1 0.1%
 
34140 66 5.9%
 
34139 78 7.0%
 

building_address_country
Categorical

MISSING
Distinct count5
Unique (%)0.5%
Missing29
Missing (%)2.6%
Memory size8.9 KiB
US
685
United States
307
USA
 
85
Estados Unidos
 
14
Florida
 
1
ValueCountFrequency (%) 
US 685 61.1%
 
United States 307 27.4%
 
USA 85 7.6%
 
Estados Unidos 14 1.2%
 
Florida 1 0.1%
 
(Missing) 29 2.6%
 

Length

Max length14
Mean length5.268510259
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 10 62.5%
 
Uppercase_Letter 5 31.2%
 
Space_Separator 1 6.2%
 
ValueCountFrequency (%) 
Latin 15 93.8%
 
Common 1 6.2%
 
ValueCountFrequency (%) 
ASCII 16 100.0%
 

building_address_full
Categorical

HIGH CARDINALITY
UNIFORM
Distinct count1101
Unique (%)98.4%
Missing2
Missing (%)0.2%
Memory size8.9 KiB
8550 A1A S Summerhouse Condos St. Augustine St. John's Florida 32080 USA
 
3
701?€?799 4th St Key West Monroe FL 33040 US
 
2
22 Beach Dr Key West Monroe FL 33040 US
 
2
760 La Fitte Rd Little Torch Key Monroe FL 33042 US
 
2
3444 N Roosevelt Blvd Key West Monroe FL 33040 US
 
2
Other values (1096)
1108
ValueCountFrequency (%) 
8550 A1A S Summerhouse Condos St. Augustine St. John's Florida 32080 USA 3 0.3%
 
701?€?799 4th St Key West Monroe FL 33040 US 2 0.2%
 
22 Beach Dr Key West Monroe FL 33040 US 2 0.2%
 
760 La Fitte Rd Little Torch Key Monroe FL 33042 US 2 0.2%
 
3444 N Roosevelt Blvd Key West Monroe FL 33040 US 2 0.2%
 
26?€?30 Arapaho Trl Naples Collier FL 34113 US 2 0.2%
 
71 W Indies Dr Ramrod Key Monroe FL 33042 US 2 0.2%
 
350 7th Street N Naples Collier FL 34102 US 2 0.2%
 
11001 Overseas Hwy Marathon Monroe FL 33050 US 2 0.2%
 
817 Magnolia Ct Marco Island Collier FL 34145 US 2 0.2%
 
Other values (1091) 1098 97.9%
 

Length

Max length96
Mean length54.24799286
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 25 37.3%
 
Uppercase_Letter 23 34.3%
 
Decimal_Number 10 14.9%
 
Other_Punctuation 6 9.0%
 
Control 1 1.5%
 
Dash_Punctuation 1 1.5%
 
Space_Separator 1 1.5%
 
ValueCountFrequency (%) 
Latin 48 71.6%
 
Common 19 28.4%
 
ValueCountFrequency (%) 
ASCII 66 100.0%
 

assessment_type
Categorical

MISSING
Distinct count10
Unique (%)0.9%
Missing40
Missing (%)3.6%
Memory size8.9 KiB
Single Family Residence
841
Mobile Home
 
164
Apartment / Condo
 
31
Utilities
 
17
Church
 
8
Other values (5)
 
20
ValueCountFrequency (%) 
Single Family Residence 841 75.0%
 
Mobile Home 164 14.6%
 
Apartment / Condo 31 2.8%
 
Utilities 17 1.5%
 
Church 8 0.7%
 
Retail Store 7 0.6%
 
Hotel / Motel 6 0.5%
 
Restaurant 3 0.3%
 
Industrial 2 0.2%
 
Hospital 2 0.2%
 
(Missing) 40 3.6%
 

Length

Max length23
Mean length19.82426405
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 18 62.1%
 
Uppercase_Letter 9 31.0%
 
Space_Separator 1 3.4%
 
Other_Punctuation 1 3.4%
 
ValueCountFrequency (%) 
Latin 27 93.1%
 
Common 2 6.9%
 
ValueCountFrequency (%) 
ASCII 29 100.0%
 

assessment_type_other
Categorical

MISSING
Distinct count29
Unique (%)72.5%
Missing1081
Missing (%)96.4%
Memory size8.9 KiB
Gravestone
5
Multiple Family Residence
 
4
RV
 
3
Marina
 
3
Traffic sign
 
1
Other values (24)
24
ValueCountFrequency (%) 
Gravestone 5 0.4%
 
Multiple Family Residence 4 0.4%
 
RV 3 0.3%
 
Marina 3 0.3%
 
Traffic sign 1 0.1%
 
Cemetery Office 1 0.1%
 
Gas station 1 0.1%
 
Wooden bridge 1 0.1%
 
Gas station canopy 1 0.1%
 
Radio tower 1 0.1%
 
Other values (19) 19 1.7%
 
(Missing) 1081 96.4%
 

Length

Max length25
Mean length3.330062444
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 21 60.0%
 
Uppercase_Letter 13 37.1%
 
Space_Separator 1 2.9%
 
ValueCountFrequency (%) 
Latin 34 97.1%
 
Common 1 2.9%
 
ValueCountFrequency (%) 
ASCII 35 100.0%
 

year_built
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
SKEWED
Distinct count81
Unique (%)7.8%
Missing81
Missing (%)7.2%
Infinite0
Infinite (%)0.0%
Mean1981.2615384615385
Minimum0.0
Maximum2018.0
Zeros1
Zeros (%)0.1%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile1949.95
Q11973
median1985
Q31996
95-th percentile2009
Maximum2018
Range2018
Interquartile range (IQR)23

Descriptive statistics

Standard deviation64.27340888
Coefficient of variation (CV)0.03244064836
Kurtosis871.0647952
Mean1981.261538
Median Absolute Deviation (MAD)12
Skewness-28.25839657
Sum2060512
Variance4131.071089
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1985 39 3.5%
 
1987 35 3.1%
 
1990 33 2.9%
 
1986 31 2.8%
 
1977 27 2.4%
 
1980 25 2.2%
 
1988 24 2.1%
 
2000 23 2.1%
 
1983 23 2.1%
 
1984 22 2.0%
 
Other values (71) 758 67.6%
 
(Missing) 81 7.2%
 
ValueCountFrequency (%) 
0 1 0.1%
 
1913 1 0.1%
 
1925 19 1.7%
 
1926 1 0.1%
 
1930 7 0.6%
 
ValueCountFrequency (%) 
2018 1 0.1%
 
2017 8 0.7%
 
2016 13 1.2%
 
2015 6 0.5%
 
2014 5 0.4%
 

effective_year_built
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
SKEWED
Distinct count79
Unique (%)8.1%
Missing145
Missing (%)12.9%
Infinite0
Infinite (%)0.0%
Mean1988.3401639344263
Minimum0.0
Maximum2017.0
Zeros1
Zeros (%)0.1%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile1953
Q11982
median1995
Q32003
95-th percentile2012
Maximum2017
Range2017
Interquartile range (IQR)21

Descriptive statistics

Standard deviation66.26039592
Coefficient of variation (CV)0.03332447693
Kurtosis833.8052407
Mean1988.340164
Median Absolute Deviation (MAD)9
Skewness-27.79443758
Sum1940620
Variance4390.440067
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2003 51 4.5%
 
2000 49 4.4%
 
1995 41 3.7%
 
1997 38 3.4%
 
2005 35 3.1%
 
1998 31 2.8%
 
1999 31 2.8%
 
2002 26 2.3%
 
2007 25 2.2%
 
1989 24 2.1%
 
Other values (69) 625 55.8%
 
(Missing) 145 12.9%
 
ValueCountFrequency (%) 
0 1 0.1%
 
1913 1 0.1%
 
1925 12 1.1%
 
1926 1 0.1%
 
1930 6 0.5%
 
ValueCountFrequency (%) 
2017 8 0.7%
 
2016 11 1.0%
 
2015 9 0.8%
 
2014 6 0.5%
 
2013 7 0.6%
 

number_of_stories
Real number (ℝ≥0)

MISSING
Distinct count11
Unique (%)1.0%
Missing57
Missing (%)5.1%
Infinite0
Infinite (%)0.0%
Mean1.3073308270676691
Minimum0.0
Maximum19.0
Zeros1
Zeros (%)0.1%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile1
Q11
median1
Q31
95-th percentile2
Maximum19
Range19
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.9178397167
Coefficient of variation (CV)0.7020715015
Kurtosis166.4985378
Mean1.307330827
Median Absolute Deviation (MAD)0
Skewness10.28661791
Sum1391
Variance0.8424297456
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
1 827 73.8%
 
2 187 16.7%
 
3 33 2.9%
 
5 7 0.6%
 
1.5 4 0.4%
 
19 1 0.1%
 
6 1 0.1%
 
0 1 0.1%
 
7 1 0.1%
 
14 1 0.1%
 
(Missing) 57 5.1%
 
ValueCountFrequency (%) 
0 1 0.1%
 
1 827 73.8%
 
1.5 4 0.4%
 
2 187 16.7%
 
3 33 2.9%
 
ValueCountFrequency (%) 
19 1 0.1%
 
14 1 0.1%
 
7 1 0.1%
 
6 1 0.1%
 
5 7 0.6%
 

roof_shape
Categorical

MISSING
Distinct count15
Unique (%)1.4%
Missing53
Missing (%)4.7%
Memory size8.9 KiB
Gable
532
Hip
193
Complex
121
Flat
 
81
Hip/Gable
 
63
Other values (10)
 
78
ValueCountFrequency (%) 
Gable 532 47.5%
 
Hip 193 17.2%
 
Complex 121 10.8%
 
Flat 81 7.2%
 
Hip/Gable 63 5.6%
 
Hip,Complex 50 4.5%
 
Gable,Complex 8 0.7%
 
Gable,Flat 5 0.4%
 
Other 5 0.4%
 
Hip/Gable,Complex 3 0.3%
 
Other values (5) 7 0.6%
 
(Missing) 53 4.7%
 

Length

Max length17
Mean length5.332738626
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 13 65.0%
 
Uppercase_Letter 5 25.0%
 
Other_Punctuation 2 10.0%
 
ValueCountFrequency (%) 
Latin 18 90.0%
 
Common 2 10.0%
 
ValueCountFrequency (%) 
ASCII 20 100.0%
 

roof_shape_other
Categorical

MISSING
Distinct count7
Unique (%)70.0%
Missing1111
Missing (%)99.1%
Memory size8.9 KiB
Mansard
3
Rounded
2
Flat roof in the center with sloping gables on two sides
1
First floor gable, upper floor monoslope
1
geodesic dome
1
Other values (2)
2
ValueCountFrequency (%) 
Mansard 3 0.3%
 
Rounded 2 0.2%
 
Flat roof in the center with sloping gables on two sides 1 0.1%
 
First floor gable, upper floor monoslope 1 0.1%
 
geodesic dome 1 0.1%
 
Mansard roof 1 0.1%
 
Gable/Flat 1 0.1%
 
(Missing) 1111 99.1%
 

Length

Max length56
Mean length3.12132025
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 19 73.1%
 
Uppercase_Letter 4 15.4%
 
Other_Punctuation 2 7.7%
 
Space_Separator 1 3.8%
 
ValueCountFrequency (%) 
Latin 23 88.5%
 
Common 3 11.5%
 
ValueCountFrequency (%) 
ASCII 26 100.0%
 

roof_cover
Categorical

MISSING
Distinct count11
Unique (%)1.1%
Missing136
Missing (%)12.1%
Memory size8.9 KiB
Standing Seam Metal
297
Asphalt shingles (3-tab)
222
Asphalt shingles (laminated)
171
Tile (clay)
131
Corrugated metal
 
58
Other values (6)
106
ValueCountFrequency (%) 
Standing Seam Metal 297 26.5%
 
Asphalt shingles (3-tab) 222 19.8%
 
Asphalt shingles (laminated) 171 15.3%
 
Tile (clay) 131 11.7%
 
Corrugated metal 58 5.2%
 
Metal shingle 44 3.9%
 
EPDM rubber roof 32 2.9%
 
Tile (concrete) 27 2.4%
 
Asphalt shingles (laminated),EPDM rubber roof 1 0.1%
 
0% 1 0.1%
 
(Missing) 136 12.1%
 

Length

Max length45
Mean length17.94469224
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 19 54.3%
 
Uppercase_Letter 8 22.9%
 
Decimal_Number 2 5.7%
 
Other_Punctuation 2 5.7%
 
Close_Punctuation 1 2.9%
 
Open_Punctuation 1 2.9%
 
Dash_Punctuation 1 2.9%
 
Space_Separator 1 2.9%
 
ValueCountFrequency (%) 
Latin 27 77.1%
 
Common 8 22.9%
 
ValueCountFrequency (%) 
ASCII 35 100.0%
 

roof_cover_other
Categorical

MISSING
Distinct count32
Unique (%)42.7%
Missing1046
Missing (%)93.3%
Memory size8.9 KiB
Unknown
22
Metal
13
Tar & Gravel
 
5
Asphalt composite shingle
 
2
Tar and Gravel
 
2
Other values (27)
31
ValueCountFrequency (%) 
Unknown 22 2.0%
 
Metal 13 1.2%
 
Tar & Gravel 5 0.4%
 
Asphalt composite shingle 2 0.2%
 
Tar and Gravel 2 0.2%
 
Rolled Composite Roofing 2 0.2%
 
unknown 2 0.2%
 
pvc 2 0.2%
 
TAR & GRAVEL 2 0.2%
 
Looks like asphalt shingle (3-tab) from aerial photograph 1 0.1%
 
Other values (22) 22 2.0%
 
(Missing) 1046 93.3%
 

Length

Max length57
Mean length3.599464764
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 22 47.8%
 
Uppercase_Letter 16 34.8%
 
Other_Punctuation 2 4.3%
 
Dash_Punctuation 1 2.2%
 
Decimal_Number 1 2.2%
 
Close_Punctuation 1 2.2%
 
Open_Punctuation 1 2.2%
 
Space_Separator 1 2.2%
 
Math_Symbol 1 2.2%
 
ValueCountFrequency (%) 
Latin 38 82.6%
 
Common 8 17.4%
 
ValueCountFrequency (%) 
ASCII 46 100.0%
 

wall_cladding
Categorical

MISSING
Distinct count19
Unique (%)1.8%
Missing90
Missing (%)8.0%
Memory size8.9 KiB
Stucco
405
Vinyl siding
334
Wood plank siding
89
Wood panel siding
83
Sheet metal
 
64
Other values (14)
 
56
ValueCountFrequency (%) 
Stucco 405 36.1%
 
Vinyl siding 334 29.8%
 
Wood plank siding 89 7.9%
 
Wood panel siding 83 7.4%
 
Sheet metal 64 5.7%
 
EIFS 11 1.0%
 
Stucco,Vinyl siding 9 0.8%
 
Stucco,Wood panel siding 8 0.7%
 
Stucco,Wood plank siding 8 0.7%
 
Wood plank siding,EIFS 5 0.4%
 
Other values (9) 15 1.3%
 
(Missing) 90 8.0%
 

Length

Max length42
Mean length10.16859946
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 19 67.9%
 
Uppercase_Letter 7 25.0%
 
Space_Separator 1 3.6%
 
Other_Punctuation 1 3.6%
 
ValueCountFrequency (%) 
Latin 26 92.9%
 
Common 2 7.1%
 
ValueCountFrequency (%) 
ASCII 28 100.0%
 

wall_cladding_other
Categorical

MISSING
Distinct count14
Unique (%)35.0%
Missing1081
Missing (%)96.4%
Memory size8.9 KiB
Unknown
18
Concrete Siding
6
Wood shingle
 
3
Hardiboard
 
2
Hardie Board
 
2
Other values (9)
9
ValueCountFrequency (%) 
Unknown 18 1.6%
 
Concrete Siding 6 0.5%
 
Wood shingle 3 0.3%
 
Hardiboard 2 0.2%
 
Hardie Board 2 0.2%
 
Heavy Stone 1 0.1%
 
Unkwnonw 1 0.1%
 
Stucco & wood paneling 1 0.1%
 
Tile 1 0.1%
 
Concrete STUCCO 1 0.1%
 
Other values (4) 4 0.4%
 
(Missing) 1081 96.4%
 

Length

Max length22
Mean length3.262265834
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 22 66.7%
 
Uppercase_Letter 9 27.3%
 
Space_Separator 1 3.0%
 
Other_Punctuation 1 3.0%
 
ValueCountFrequency (%) 
Latin 31 93.9%
 
Common 2 6.1%
 
ValueCountFrequency (%) 
ASCII 33 100.0%
 

first_floor_elevation_ft
Real number (ℝ≥0)

ZEROS
Distinct count22
Unique (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.29014272970562
Minimum0.0
Maximum14.0
Zeros513
Zeros (%)45.8%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1.75
Q38
95-th percentile10
Maximum14
Range14
Interquartile range (IQR)8

Descriptive statistics

Standard deviation3.939250583
Coefficient of variation (CV)1.197288661
Kurtosis-1.05023717
Mean3.29014273
Median Absolute Deviation (MAD)1.75
Skewness0.7395883424
Sum3688.25
Variance15.51769516
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0 513 45.8%
 
8 229 20.4%
 
2 112 10.0%
 
9 52 4.6%
 
10 41 3.7%
 
1 36 3.2%
 
1.75 29 2.6%
 
3 25 2.2%
 
12 24 2.1%
 
2.25 14 1.2%
 
Other values (12) 46 4.1%
 
ValueCountFrequency (%) 
0 513 45.8%
 
1 36 3.2%
 
1.5 6 0.5%
 
1.75 29 2.6%
 
2 112 10.0%
 
ValueCountFrequency (%) 
14 4 0.4%
 
13 1 0.1%
 
12 24 2.1%
 
11 3 0.3%
 
10 41 3.7%
 

other_details
Categorical

HIGH CARDINALITY
MISSING
UNIFORM
Distinct count99
Unique (%)95.2%
Missing1017
Missing (%)90.7%
Memory size8.9 KiB
1. 1st floor: Stucco; 2nd floor: Wood panel.
 
4
1. Roof cover not visible in photographs.
 
2
Shingles old
 
2
Timber frame on top of concret piers and slab
 
1
1. 2ft water mark above ground level 2. Wall Cladding: 1st floor Brick Veneer, 2nd floor Vinyl Siding
 
1
Other values (94)
94
ValueCountFrequency (%) 
1. 1st floor: Stucco; 2nd floor: Wood panel. 4 0.4%
 
1. Roof cover not visible in photographs. 2 0.2%
 
Shingles old 2 0.2%
 
Timber frame on top of concret piers and slab 1 0.1%
 
1. 2ft water mark above ground level 2. Wall Cladding: 1st floor Brick Veneer, 2nd floor Vinyl Siding 1 0.1%
 
Screen damage 1 0.1%
 
Timber roof on masonry structure. Steel frame supports the ground kitchen floor 1 0.1%
 
Impact-Resistant Roof 1 0.1%
 
Stairway leads to an elevated first floor. Porch along two sides of the house. 1 0.1%
 
1. Roof cover not visible. 1 0.1%
 
Other values (89) 89 7.9%
 
(Missing) 1017 90.7%
 

Length

Max length318
Mean length7.694915254
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 24 35.8%
 
Uppercase_Letter 21 31.3%
 
Decimal_Number 10 14.9%
 
Other_Punctuation 7 10.4%
 
Dash_Punctuation 1 1.5%
 
Control 1 1.5%
 
Open_Punctuation 1 1.5%
 
Space_Separator 1 1.5%
 
Close_Punctuation 1 1.5%
 
ValueCountFrequency (%) 
Latin 45 67.2%
 
Common 22 32.8%
 
ValueCountFrequency (%) 
ASCII 67 100.0%
 

structural_framing_system
Categorical

MISSING
Distinct count20
Unique (%)1.9%
Missing89
Missing (%)7.9%
Memory size8.9 KiB
Unknown
442
Wood-frame
330
Masonry block (unknown reinforcement)
169
Wood-frame,Reinforced concrete
 
28
Wood-frame,Masonry block (unknown reinforcement)
 
21
Other values (15)
 
42
ValueCountFrequency (%) 
Unknown 442 39.4%
 
Wood-frame 330 29.4%
 
Masonry block (unknown reinforcement) 169 15.1%
 
Wood-frame,Reinforced concrete 28 2.5%
 
Wood-frame,Masonry block (unknown reinforcement) 21 1.9%
 
Reinforced concrete 10 0.9%
 
Masonry block (reinforced),Reinforced concrete 8 0.7%
 
Structural steel 6 0.5%
 
Masonry block (reinforced) 3 0.3%
 
Wood-frame,Reinforced masonry block 3 0.3%
 
Other values (10) 12 1.1%
 
(Missing) 89 7.9%
 

Length

Max length57
Mean length14.27832293
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 18 62.1%
 
Uppercase_Letter 6 20.7%
 
Dash_Punctuation 1 3.4%
 
Close_Punctuation 1 3.4%
 
Open_Punctuation 1 3.4%
 
Space_Separator 1 3.4%
 
Other_Punctuation 1 3.4%
 
ValueCountFrequency (%) 
Latin 24 82.8%
 
Common 5 17.2%
 
ValueCountFrequency (%) 
ASCII 29 100.0%
 
Distinct count12
Unique (%)54.5%
Missing1099
Missing (%)98.0%
Memory size8.9 KiB
Metal/Aluminium
11
Concrete columns at first floor
 
1
Prestressed concrete poles
 
1
RC elevated platform
 
1
concrete piers
 
1
Other values (7)
7
ValueCountFrequency (%) 
Metal/Aluminium 11 1.0%
 
Concrete columns at first floor 1 0.1%
 
Prestressed concrete poles 1 0.1%
 
RC elevated platform 1 0.1%
 
concrete piers 1 0.1%
 
Concrete columns 1 0.1%
 
dome elevated on wood piers 1 0.1%
 
Metal 1 0.1%
 
ICF 1 0.1%
 
concrete block piers 1 0.1%
 
Other values (2) 2 0.2%
 
(Missing) 1099 98.0%
 

Length

Max length31
Mean length3.264942016
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 19 57.6%
 
Uppercase_Letter 8 24.2%
 
Other_Punctuation 3 9.1%
 
Decimal_Number 2 6.1%
 
Space_Separator 1 3.0%
 
ValueCountFrequency (%) 
Latin 27 81.8%
 
Common 6 18.2%
 
ValueCountFrequency (%) 
ASCII 33 100.0%
 

roof_sheathing_nail_spacing
Categorical

MISSING
Distinct count2
Unique (%)18.2%
Missing1110
Missing (%)99.0%
Memory size8.9 KiB
6:12
9
6:06
2
ValueCountFrequency (%) 
6:12 9 0.8%
 
6:06 2 0.2%
 
(Missing) 1110 99.0%
 

Length

Max length4
Mean length3.009812667
Min length3
ValueCountFrequency (%) 
Decimal_Number 4 57.1%
 
Lowercase_Letter 2 28.6%
 
Other_Punctuation 1 14.3%
 
ValueCountFrequency (%) 
Common 5 71.4%
 
Latin 2 28.6%
 
ValueCountFrequency (%) 
ASCII 7 100.0%
 
Distinct count2
Unique (%)0.2%
Missing1
Missing (%)0.1%
Memory size8.9 KiB
Unknown
1119
8D (2-1/2" long
 
1
ValueCountFrequency (%) 
Unknown 1119 99.8%
 
8D (2-1/2" long 1 0.1%
 
(Missing) 1 0.1%
 

Length

Max length15
Mean length7.003568243
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 7 41.2%
 
Decimal_Number 3 17.6%
 
Uppercase_Letter 2 11.8%
 
Other_Punctuation 2 11.8%
 
Open_Punctuation 1 5.9%
 
Dash_Punctuation 1 5.9%
 
Space_Separator 1 5.9%
 
ValueCountFrequency (%) 
Latin 9 52.9%
 
Common 8 47.1%
 
ValueCountFrequency (%) 
ASCII 17 100.0%
 
Distinct count1
Unique (%)100.0%
Missing1120
Missing (%)99.9%
Memory size8.9 KiB
Staples!
1
ValueCountFrequency (%) 
Staples! 1 0.1%
 
(Missing) 1120 99.9%
 

Length

Max length8
Mean length3.004460303
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 7 77.8%
 
Other_Punctuation 1 11.1%
 
Uppercase_Letter 1 11.1%
 
ValueCountFrequency (%) 
Latin 8 88.9%
 
Common 1 11.1%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

roof_to_wall_connection
Categorical

MISSING
Distinct count5
Unique (%)1.0%
Missing631
Missing (%)56.3%
Memory size8.9 KiB
Unknown
466
"e.g., H2.5"
 
11
wraps around truss
 
10
Toe-nail
 
2
wraps around truss,Toe-nail
 
1
ValueCountFrequency (%) 
Unknown 466 41.6%
 
"e.g., H2.5" 11 1.0%
 
wraps around truss 10 0.9%
 
Toe-nail 2 0.2%
 
wraps around truss,Toe-nail 1 0.1%
 
(Missing) 631 56.3%
 

Length

Max length27
Mean length4.915254237
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 15 60.0%
 
Uppercase_Letter 3 12.0%
 
Other_Punctuation 3 12.0%
 
Decimal_Number 2 8.0%
 
Space_Separator 1 4.0%
 
Dash_Punctuation 1 4.0%
 
ValueCountFrequency (%) 
Latin 18 72.0%
 
Common 7 28.0%
 
ValueCountFrequency (%) 
ASCII 25 100.0%
 

roof_to_wall_connection_other
Unsupported

MISSING
REJECTED
UNSUPPORTED
Missing1121
Missing (%)100.0%
Memory size8.9 KiB

opening_protection
Categorical

MISSING
Distinct count8
Unique (%)1.0%
Missing285
Missing (%)25.4%
Memory size8.9 KiB
None
373
Shutters
363
Impact-resistant glass
 
54
Plywood/OSB
 
34
Shutters,Plywood/OSB
 
6
Other values (3)
 
6
ValueCountFrequency (%) 
None 373 33.3%
 
Shutters 363 32.4%
 
Impact-resistant glass 54 4.8%
 
Plywood/OSB 34 3.0%
 
Shutters,Plywood/OSB 6 0.5%
 
Shutters,Impact-resistant glass 4 0.4%
 
Plywood/OSB,Shutters 1 0.1%
 
Impact-resistant glass,Shutters 1 0.1%
 
(Missing) 285 25.4%
 

Length

Max length31
Mean length6.340767172
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 18 64.3%
 
Uppercase_Letter 6 21.4%
 
Other_Punctuation 2 7.1%
 
Space_Separator 1 3.6%
 
Dash_Punctuation 1 3.6%
 
ValueCountFrequency (%) 
Latin 24 85.7%
 
Common 4 14.3%
 
ValueCountFrequency (%) 
ASCII 28 100.0%
 

opening_protection_other
Categorical

MISSING
Distinct count10
Unique (%)15.4%
Missing1056
Missing (%)94.2%
Memory size8.9 KiB
Unknown
48
unknown
 
9
home made
 
1
Wood planks nailed centered at 4in. along the width of windows. Glass still exposed.
 
1
Wood planks nailed every 8in along the width of the windows
 
1
Other values (5)
 
5
ValueCountFrequency (%) 
Unknown 48 4.3%
 
unknown 9 0.8%
 
home made 1 0.1%
 
Wood planks nailed centered at 4in. along the width of windows. Glass still exposed. 1 0.1%
 
Wood planks nailed every 8in along the width of the windows 1 0.1%
 
Uknown 1 0.1%
 
Canvas material 1 0.1%
 
Unknowon 1 0.1%
 
Decorative iron cages. 1 0.1%
 
Other 1 0.1%
 
(Missing) 1056 94.2%
 

Length

Max length84
Mean length3.368421053
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 22 68.8%
 
Uppercase_Letter 6 18.8%
 
Decimal_Number 2 6.2%
 
Space_Separator 1 3.1%
 
Other_Punctuation 1 3.1%
 
ValueCountFrequency (%) 
Latin 28 87.5%
 
Common 4 12.5%
 
ValueCountFrequency (%) 
ASCII 32 100.0%
 

garage_door
Boolean

MISSING
Distinct count2
Unique (%)0.2%
Missing95
Missing (%)8.5%
Memory size8.9 KiB
no
689
yes
337
(Missing)
 
95
ValueCountFrequency (%) 
no 689 61.5%
 
yes 337 30.1%
 
(Missing) 95 8.5%
 

garage_door_location
Categorical

MISSING
Distinct count3
Unique (%)2.5%
Missing1002
Missing (%)89.4%
Memory size8.9 KiB
Either side of the windward wall
46
Facing the oncoming wind
40
Opposite side of the windward
33
ValueCountFrequency (%) 
Either side of the windward wall 46 4.1%
 
Facing the oncoming wind 40 3.6%
 
Opposite side of the windward 33 2.9%
 
(Missing) 1002 89.4%
 

Length

Max length32
Mean length5.704727921
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 17 81.0%
 
Uppercase_Letter 3 14.3%
 
Space_Separator 1 4.8%
 
ValueCountFrequency (%) 
Latin 20 95.2%
 
Common 1 4.8%
 
ValueCountFrequency (%) 
ASCII 21 100.0%
 

garage_door_failure
Categorical

MISSING
Distinct count3
Unique (%)0.9%
Missing770
Missing (%)68.7%
Memory size8.9 KiB
No
284
Unknown
 
37
Yes
 
30
ValueCountFrequency (%) 
No 284 25.3%
 
Unknown 37 3.3%
 
Yes 30 2.7%
 
(Missing) 770 68.7%
 

Length

Max length7
Mean length2.87867975
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 7 70.0%
 
Uppercase_Letter 3 30.0%
 
ValueCountFrequency (%) 
Latin 10 100.0%
 
ValueCountFrequency (%) 
ASCII 10 100.0%
 

other_structural_details
Categorical

HIGH CARDINALITY
MISSING
UNIFORM
Distinct count73
Unique (%)90.1%
Missing1040
Missing (%)92.8%
Memory size8.9 KiB
1. Impact glass assumed from photos.
 
3
1. 1st floor: RC columns; 2nd floor: Wood-frame.
 
3
1. Structural Framing: 1st floor RC, 2nd floor Wood-frame
 
2
1. 1st floor: RC; 2nd floor: Wood-frame.
 
2
1. RC framing system with reinforced CMU likely.
 
2
Other values (68)
69
ValueCountFrequency (%) 
1. Impact glass assumed from photos. 3 0.3%
 
1. 1st floor: RC columns; 2nd floor: Wood-frame. 3 0.3%
 
1. Structural Framing: 1st floor RC, 2nd floor Wood-frame 2 0.2%
 
1. 1st floor: RC; 2nd floor: Wood-frame. 2 0.2%
 
1. RC framing system with reinforced CMU likely. 2 0.2%
 
1. RC framing with reinforced CMU likely. 2 0.2%
 
1. Only one window shows shutter protection in photographs. 1 0.1%
 
The structure is mainly of concrete block, but it was later enclosed with wood frame. 1 0.1%
 
1. No opening protection visible. 1 0.1%
 
Owner think might be due to tornado 1 0.1%
 
Other values (63) 63 5.6%
 
(Missing) 1040 92.8%
 

Length

Max length173
Mean length6.807314897
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 24 39.3%
 
Uppercase_Letter 18 29.5%
 
Decimal_Number 7 11.5%
 
Other_Punctuation 7 11.5%
 
Control 1 1.6%
 
Open_Punctuation 1 1.6%
 
Dash_Punctuation 1 1.6%
 
Close_Punctuation 1 1.6%
 
Space_Separator 1 1.6%
 
ValueCountFrequency (%) 
Latin 42 68.9%
 
Common 19 31.1%
 
ValueCountFrequency (%) 
ASCII 61 100.0%
 

damage_modes
Categorical

MISSING
Distinct count13
Unique (%)1.3%
Missing149
Missing (%)13.3%
Memory size8.9 KiB
Wind
817
Wind,Surge
 
89
Surge
 
32
Wind,Tree
 
11
Wind,Flood,Surge
 
5
Other values (8)
 
18
ValueCountFrequency (%) 
Wind 817 72.9%
 
Wind,Surge 89 7.9%
 
Surge 32 2.9%
 
Wind,Tree 11 1.0%
 
Wind,Flood,Surge 5 0.4%
 
Surge,Wind 4 0.4%
 
Wind,Flood 4 0.4%
 
Tree 3 0.3%
 
Wind,Surge,Tree 2 0.2%
 
Flood,Surge 2 0.2%
 
Other values (3) 3 0.3%
 
(Missing) 149 13.3%
 

Length

Max length16
Mean length4.571810883
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 10 66.7%
 
Uppercase_Letter 4 26.7%
 
Other_Punctuation 1 6.7%
 
ValueCountFrequency (%) 
Latin 14 93.3%
 
Common 1 6.7%
 
ValueCountFrequency (%) 
ASCII 15 100.0%
 

damage_modes_other
Categorical

MISSING
Distinct count7
Unique (%)87.5%
Missing1113
Missing (%)99.3%
Memory size8.9 KiB
Other
2
Rain
1
Soil failure
1
scouring
1
Wind and Debris
1
Other values (2)
2
ValueCountFrequency (%) 
Other 2 0.2%
 
Rain 1 0.1%
 
Soil failure 1 0.1%
 
scouring 1 0.1%
 
Wind and Debris 1 0.1%
 
Boot hit the bridge during the storm 1 0.1%
 
Unknown 1 0.1%
 
(Missing) 1113 99.3%
 

Length

Max length36
Mean length3.062444246
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 19 70.4%
 
Uppercase_Letter 7 25.9%
 
Space_Separator 1 3.7%
 
ValueCountFrequency (%) 
Latin 26 96.3%
 
Common 1 3.7%
 
ValueCountFrequency (%) 
ASCII 27 100.0%
 

number_of_sides_used
Real number (ℝ≥0)

MISSING
Distinct count5
Unique (%)0.5%
Missing86
Missing (%)7.7%
Infinite0
Infinite (%)0.0%
Mean2.2483091787439613
Minimum0.0
Maximum4.0
Zeros5
Zeros (%)0.4%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile1
Q11
median2
Q33
95-th percentile4
Maximum4
Range4
Interquartile range (IQR)2

Descriptive statistics

Standard deviation0.989883324
Coefficient of variation (CV)0.4402790032
Kurtosis-0.8734598449
Mean2.248309179
Median Absolute Deviation (MAD)1
Skewness0.2601457513
Sum2327
Variance0.9798689952
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2 375 33.5%
 
1 261 23.3%
 
3 260 23.2%
 
4 134 12.0%
 
0 5 0.4%
 
(Missing) 86 7.7%
 
ValueCountFrequency (%) 
0 5 0.4%
 
1 261 23.3%
 
2 375 33.5%
 
3 260 23.2%
 
4 134 12.0%
 
ValueCountFrequency (%) 
4 134 12.0%
 
3 260 23.2%
 
2 375 33.5%
 
1 261 23.3%
 
0 5 0.4%
 
Distinct count2
Unique (%)0.2%
Missing79
Missing (%)7.0%
Memory size8.9 KiB
yes
923
no
 
119
(Missing)
 
79
ValueCountFrequency (%) 
yes 923 82.3%
 
no 119 10.6%
 
(Missing) 79 7.0%
 

roof_cover_dmg
Categorical

Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
460
10%
285
20%
119
30%
 
65
40%
 
55
Other values (6)
137
ValueCountFrequency (%) 
0% 460 41.0%
 
10% 285 25.4%
 
20% 119 10.6%
 
30% 65 5.8%
 
40% 55 4.9%
 
100% 36 3.2%
 
50% 35 3.1%
 
60% 27 2.4%
 
80% 14 1.2%
 
90% 13 1.2%
 

Length

Max length4
Mean length2.62176628
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 
Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
918
10%
 
61
20%
 
37
100%
 
31
30%
 
23
Other values (6)
 
51
ValueCountFrequency (%) 
0% 918 81.9%
 
10% 61 5.4%
 
20% 37 3.3%
 
100% 31 2.8%
 
30% 23 2.1%
 
50% 15 1.3%
 
40% 11 1.0%
 
90% 7 0.6%
 
70% 6 0.5%
 
80% 6 0.5%
 

Length

Max length4
Mean length2.208742194
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 
Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
997
10%
 
31
100%
 
26
20%
 
17
30%
 
16
Other values (6)
 
34
ValueCountFrequency (%) 
0% 997 88.9%
 
10% 31 2.8%
 
100% 26 2.3%
 
20% 17 1.5%
 
30% 16 1.4%
 
50% 10 0.9%
 
70% 7 0.6%
 
60% 7 0.6%
 
40% 5 0.4%
 
80% 3 0.3%
 

Length

Max length4
Mean length2.133809099
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

wall_cover_dmg
Categorical

Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
713
10%
219
20%
 
69
30%
 
37
40%
 
30
Other values (6)
 
53
ValueCountFrequency (%) 
0% 713 63.6%
 
10% 219 19.5%
 
20% 69 6.2%
 
30% 37 3.3%
 
40% 30 2.7%
 
100% 16 1.4%
 
50% 15 1.3%
 
60% 7 0.6%
 
70% 6 0.5%
 
80% 6 0.5%
 

Length

Max length4
Mean length2.37823372
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 
Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
996
10%
 
37
20%
 
19
30%
 
16
100%
 
15
Other values (6)
 
38
ValueCountFrequency (%) 
0% 996 88.8%
 
10% 37 3.3%
 
20% 19 1.7%
 
30% 16 1.4%
 
100% 15 1.3%
 
50% 13 1.2%
 
60% 8 0.7%
 
40% 7 0.6%
 
70% 5 0.4%
 
90% 3 0.3%
 

Length

Max length4
Mean length2.124888492
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 
Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
1038
100%
 
14
10%
 
13
50%
 
12
20%
 
12
Other values (6)
 
32
ValueCountFrequency (%) 
0% 1038 92.6%
 
100% 14 1.2%
 
10% 13 1.2%
 
50% 12 1.1%
 
20% 12 1.1%
 
30% 9 0.8%
 
40% 6 0.5%
 
80% 6 0.5%
 
60% 5 0.4%
 
70% 3 0.3%
 

Length

Max length4
Mean length2.086529884
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

windows_dmg
Categorical

Distinct count11
Unique (%)1.0%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
1003
10%
 
37
100%
 
18
20%
 
18
50%
 
16
Other values (6)
 
29
ValueCountFrequency (%) 
0% 1003 89.5%
 
10% 37 3.3%
 
100% 18 1.6%
 
20% 18 1.6%
 
50% 16 1.4%
 
30% 9 0.8%
 
40% 7 0.6%
 
70% 5 0.4%
 
80% 4 0.4%
 
90% 2 0.2%
 

Length

Max length4
Mean length2.12132025
Min length2
ValueCountFrequency (%) 
Decimal_Number 10 90.9%
 
Other_Punctuation 1 9.1%
 
ValueCountFrequency (%) 
Common 11 100.0%
 
ValueCountFrequency (%) 
ASCII 11 100.0%
 

doors_dmg
Categorical

Distinct count9
Unique (%)0.8%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
0%
1051
100%
 
27
50%
 
14
30%
 
8
10%
 
8
Other values (4)
 
13
ValueCountFrequency (%) 
0% 1051 93.8%
 
100% 27 2.4%
 
50% 14 1.2%
 
30% 8 0.7%
 
10% 8 0.7%
 
20% 7 0.6%
 
80% 3 0.3%
 
90% 2 0.2%
 
60% 1 0.1%
 

Length

Max length4
Mean length2.086529884
Min length2
ValueCountFrequency (%) 
Decimal_Number 8 88.9%
 
Other_Punctuation 1 11.1%
 
ValueCountFrequency (%) 
Common 9 100.0%
 
ValueCountFrequency (%) 
ASCII 9 100.0%
 

damage_description
Categorical

HIGH CARDINALITY
MISSING
Distinct count344
Unique (%)77.7%
Missing678
Missing (%)60.5%
Memory size8.9 KiB
No visible damage
 
60
Few shingles displaced
 
10
Personal items outside, suggests interior water damage.
 
8
1. Minor roof cover damage.
 
6
No visible damage.
 
6
Other values (339)
353
ValueCountFrequency (%) 
No visible damage 60 5.4%
 
Few shingles displaced 10 0.9%
 
Personal items outside, suggests interior water damage. 8 0.7%
 
1. Minor roof cover damage. 6 0.5%
 
No visible damage. 6 0.5%
 
See General Notes. 4 0.4%
 
Few shingles blown out 3 0.3%
 
Gutters damaged 2 0.2%
 
Soffit damage 2 0.2%
 
Interior damage due to surge 2 0.2%
 
Other values (334) 340 30.3%
 
(Missing) 678 60.5%
 

Length

Max length336
Mean length21.92685103
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 25 37.9%
 
Uppercase_Letter 20 30.3%
 
Decimal_Number 7 10.6%
 
Other_Punctuation 7 10.6%
 
Math_Symbol 2 3.0%
 
Control 1 1.5%
 
Close_Punctuation 1 1.5%
 
Open_Punctuation 1 1.5%
 
Dash_Punctuation 1 1.5%
 
Space_Separator 1 1.5%
 
ValueCountFrequency (%) 
Latin 45 68.2%
 
Common 21 31.8%
 
ValueCountFrequency (%) 
ASCII 66 100.0%
 

water_height_inches
Real number (ℝ≥0)

MISSING
Distinct count20
Unique (%)35.1%
Missing1064
Missing (%)94.9%
Infinite0
Infinite (%)0.0%
Mean28.70175438596491
Minimum0.0
Maximum120.0
Zeros4
Zeros (%)0.4%
Memory size8.9 KiB

Quantile statistics

Minimum0
5-th percentile0
Q118
median24
Q336
95-th percentile52
Maximum120
Range120
Interquartile range (IQR)18

Descriptive statistics

Standard deviation20.63367992
Coefficient of variation (CV)0.7188996059
Kurtosis9.309962079
Mean28.70175439
Median Absolute Deviation (MAD)10
Skewness2.49605869
Sum1636
Variance425.7487469
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
22 8 0.7%
 
36 7 0.6%
 
24 7 0.6%
 
12 6 0.5%
 
30 4 0.4%
 
34 4 0.4%
 
18 4 0.4%
 
0 4 0.4%
 
29 2 0.2%
 
15 1 0.1%
 
Other values (10) 10 0.9%
 
(Missing) 1064 94.9%
 
ValueCountFrequency (%) 
0 4 0.4%
 
12 6 0.5%
 
15 1 0.1%
 
17 1 0.1%
 
18 4 0.4%
 
ValueCountFrequency (%) 
120 1 0.1%
 
108 1 0.1%
 
60 1 0.1%
 
50 1 0.1%
 
48 1 0.1%
 

structure_usable
Boolean

MISSING
Distinct count2
Unique (%)0.2%
Missing54
Missing (%)4.8%
Memory size8.9 KiB
yes
817
no
250
(Missing)
 
54
ValueCountFrequency (%) 
yes 817 72.9%
 
no 250 22.3%
 
(Missing) 54 4.8%
 

qc_id
Categorical

Distinct count20
Unique (%)1.8%
Missing4
Missing (%)0.4%
Memory size8.9 KiB
Fernando Plaz
286
Aravind Viswanathan
227
Courtney Hodges
155
Robyn Manhard
146
Andrew Bartolini
141
Other values (15)
162
ValueCountFrequency (%) 
Fernando Plaz 286 25.5%
 
Aravind Viswanathan 227 20.2%
 
Courtney Hodges 155 13.8%
 
Robyn Manhard 146 13.0%
 
Andrew Bartolini 141 12.6%
 
Robyn Manhard and Andrew Bartolini 82 7.3%
 
David Roueche 24 2.1%
 
Brett Davis 13 1.2%
 
Andrei Perim 10 0.9%
 
Saman Farhangdoust 8 0.7%
 
Other values (10) 25 2.2%
 

Length

Max length47
Mean length16.544157
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 20 58.8%
 
Uppercase_Letter 12 35.3%
 
Space_Separator 1 2.9%
 
Other_Punctuation 1 2.9%
 
ValueCountFrequency (%) 
Latin 32 94.1%
 
Common 2 5.9%
 
ValueCountFrequency (%) 
ASCII 34 100.0%
 

qc_code
Categorical

Distinct count2
Unique (%)0.2%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2a
1035
2b
 
86
ValueCountFrequency (%) 
2a 1035 92.3%
 
2b 86 7.7%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Lowercase_Letter 2 66.7%
 
Decimal_Number 1 33.3%
 
ValueCountFrequency (%) 
Latin 2 66.7%
 
Common 1 33.3%
 
ValueCountFrequency (%) 
ASCII 3 100.0%
 

qc_notes
Categorical

HIGH CARDINALITY
MISSING
Distinct count919
Unique (%)85.6%
Missing48
Missing (%)4.3%
Memory size8.9 KiB
Location adjusted. Aerial photo added. All other available data entered.
 
25
Updated address and coordinates. Assigned building material, damage ratios and overall damage rating.
 
13
Adjusted coordinates. Assigned building material, damage ratios and overall damage rating.
 
12
Updated address and coordinates. Assigned building material and overall damage rating.
 
12
Coordinates adjusted. Aerial photo added. Year built/effective year built added.
 
12
Other values (914)
999
ValueCountFrequency (%) 
Location adjusted. Aerial photo added. All other available data entered. 25 2.2%
 
Updated address and coordinates. Assigned building material, damage ratios and overall damage rating. 13 1.2%
 
Adjusted coordinates. Assigned building material, damage ratios and overall damage rating. 12 1.1%
 
Updated address and coordinates. Assigned building material and overall damage rating. 12 1.1%
 
Coordinates adjusted. Aerial photo added. Year built/effective year built added. 12 1.1%
 
Coordinates adjusted. Editorial check. Assigned overall damage rating. 7 0.6%
 
Updated address and coordinates. Editorial check. Assigned overall damage rating. 7 0.6%
 
Adjusted coordinates. Editorial check. Assigned overall damage rating. 6 0.5%
 
Coordinates adjusted. Editorial changes. Assigned overall damage rating. 6 0.5%
 
Aerial photo added. Year built/effective year built added. 6 0.5%
 
Other values (909) 967 86.3%
 
(Missing) 48 4.3%
 

Length

Max length747
Mean length192.1570027
Min length3
ValueCountFrequency (%) 
Lowercase_Letter 26 33.8%
 
Uppercase_Letter 25 32.5%
 
Decimal_Number 10 13.0%
 
Other_Punctuation 10 13.0%
 
Math_Symbol 1 1.3%
 
Dash_Punctuation 1 1.3%
 
Control 1 1.3%
 
Open_Punctuation 1 1.3%
 
Space_Separator 1 1.3%
 
Close_Punctuation 1 1.3%
 
ValueCountFrequency (%) 
Latin 51 66.2%
 
Common 26 33.8%
 
ValueCountFrequency (%) 
ASCII 77 100.0%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

Sample

First rows

fulcrum_idlatitudelongitudename_of_surveyordate_of_surveytype_of_disaster_projectgeneral_notesphotosphotos_captionphotos_urloverall_building_conditionbuilding_address_sub_thoroughfarebuilding_address_thoroughfarebuilding_address_suitebuilding_address_localitybuilding_address_sub_admin_areabuilding_address_admin_areabuilding_address_postal_codebuilding_address_countrybuilding_address_fullassessment_typeassessment_type_otheryear_builteffective_year_builtnumber_of_storiesroof_shaperoof_shape_otherroof_coverroof_cover_otherwall_claddingwall_cladding_otherfirst_floor_elevation_ftother_detailsstructural_framing_systemstructural_framing_system_otherroof_sheathing_nail_spacingroof_sheathing_nail_sizeroof_sheathing_nail_size_otherroof_to_wall_connectionroof_to_wall_connection_otheropening_protectionopening_protection_othergarage_doorgarage_door_locationgarage_door_failureother_structural_detailsdamage_modesdamage_modes_othernumber_of_sides_useddamage_visible_in_photosroof_cover_dmgroof_sheathing_dmgroof_structure_dmgwall_cover_dmgwall_sheathing_dmgwall_structure_dmgwindows_dmgdoors_dmgdamage_descriptionwater_height_inchesstructure_usableqc_idqc_codeqc_notes
0cf4e5e73-25fd-46d2-9055-d3a7fed1b83626.170294-81.698241Daniel Smith9/12/2017HurricaneCMMI-1761461NaN34d42212-4da1-4fbc-97d3-32541a30b36e,09273e26-a0e9-43bc-ac10-ac87c369c919,22341f93-3172-4686-9c16-0b6df3c0a2cf,8537db33-3d65-4d81-8b03-983cd25da4c0,,,https://web.fulcrumapp.com/photos/view?photos=34d42212-4da1-4fbc-97d3-32541a30b36e%2C09273e26-a0e9-43bc-ac10-ac87c369c919%2C22341f93-3172-4686-9c16-0b6df3c0a2cf%2C8537db33-3d65-4d81-8b03-983cd25da4c02457132nd Ave SWNaNNaplesCollierFL34116.0US4571 32nd Ave SW Naples Collier FL 34116 USSingle Family ResidenceNaN1982.0NaN1.0GableNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNShuttersNaNNaNNaNNaNNaNWindNaNNaNNaN10%10%10%0%0%0%0%0%Back porch overhang failed.NaNNaNRobyn Manhard2aAdded address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted. Photos added from duplicate record. Changed damage level to Moderate. Aerial photo added. Damage ratios added.
14c5b4160-a159-4e2d-ab5b-633e0ab6ea1026.170554-81.701669Daniel Smith9/12/2017HurricaneCMMI-1761461NaN26278367-e6db-43a2-9cfb-b5b61ea9b4e7,89f39622-26c8-4058-a10c-44ffcbe2b0e8,https://web.fulcrumapp.com/photos/view?photos=26278367-e6db-43a2-9cfb-b5b61ea9b4e7%2C89f39622-26c8-4058-a10c-44ffcbe2b0e823168Tropicana BlvdNaNNaplesCollierFL34116.0US3168 Tropicana Blvd Naples Collier FL 34116 USSingle Family ResidenceNaN1996.0NaN1.0GableNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNShuttersNaNNaNNaNNaNNaNWindNaN2.0yes20%0%0%0%0%0%0%0%Roof cover damage to back of house evident in aerials.NaNNaNRobyn Manhard2aAdded address and overall building condition. Changed name of surveyor to "Daniel Smith". Moved coordinates from road to building footprint. Added aerial imagery and roof cover damage ratio.
245364fba-92df-4e4f-8f06-e3b89d6780ae26.170624-81.700674Daniel Smith9/12/2017HurricaneCMMI-1761461NaNb781a39c-0157-4bb3-b5e4-37fe658a9007,8dc4896d-9d98-499b-a310-54041369bd52,https://web.fulcrumapp.com/photos/view?photos=b781a39c-0157-4bb3-b5e4-37fe658a9007%2C8dc4896d-9d98-499b-a310-54041369bd522473831st Pl SWNaNNaplesCollierFL34116.0US4738 31st Pl SW Naples Collier FL 34116 USSingle Family ResidenceNaN1980.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNWindNaN2.0yes30%0%0%0%0%0%0%0%Extensive roof cover damage to back (south slope) of roof.NaNNaNRobyn Manhard2aAdded address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted. Aerial image added.
3b7ffb5ec-934e-4b9a-bfea-414268a382c926.170672-81.699016Daniel Smith9/12/2017HurricaneCMMI-1761461NaNae9d29ca-8113-4c5c-a3e9-d1e11ca859c3,ca1079fc-f7a9-43fd-846f-1456f0c1764e,https://web.fulcrumapp.com/photos/view?photos=ae9d29ca-8113-4c5c-a3e9-d1e11ca859c3%2Cca1079fc-f7a9-43fd-846f-1456f0c1764e1460031st Pl SWNaNNaplesCollierFL34116.0US4600 31st Pl SW Naples Collier FL 34116 USSingle Family ResidenceNaN1981.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNWindNaNNaNNaN0%0%0%10%0%0%0%0%Minor soffit damage, treated as wall cover.NaNNaNRobyn Manhard2aAdded address and overall building condition. Changed name of surveyor to "Daniel Smith". Coordinates adjusted.
464303880-d6ab-4145-8538-d81f749f761d26.174235-81.691659Daniel Smith9/12/2017HurricaneCMMI-1761461NaN5d56a147-227d-42ec-8877-a8f2492171fc,ac55cc9c-9114-40ae-a40a-4635ab01a7f0,https://web.fulcrumapp.com/photos/view?photos=5d56a147-227d-42ec-8877-a8f2492171fc%2Cac55cc9c-9114-40ae-a40a-4635ab01a7f01421429th Pl SWNaNNaplesCollierFL34116.0US4214 29th Pl SW Naples Collier FL 34116 USSingle Family ResidenceNaN2002.0NaN1.0HipNaNTile (clay)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNWindNaN2.0yes10%0%0%0%0%0%0%0%NaNNaNNaNRobyn Manhard2aChanged surveyor name to Daniel Smith. Added Overall Building Condition. Adjusted coordinates. Survey date corrected. Roof cover damage added. Aerial image added.
56b2460c5-f17d-4200-8569-76ecdf5e67c926.173686-81.689639Daniel Smith9/12/2017HurricaneCMMI-1761461NaN78a9493a-c969-4597-b73f-9dd98ec9694c,6c51b4d7-7368-4306-8720-0daa30d6d867,https://web.fulcrumapp.com/photos/view?photos=78a9493a-c969-4597-b73f-9dd98ec9694c%2C6c51b4d7-7368-4306-8720-0daa30d6d8671299541st St SWNaNNaplesCollierFL34116.0US2995 41st St SW Naples Collier FL 34116 USSingle Family ResidenceNaN1980.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN10%0%0%0%0%0%0%0%NaNNaNNaNRobyn Manhard2aAdded building address and adjusted GPS coordinates. Added building condition. Changed Surveyor name to Daniel Smith. Survey date corrected. 10% roof cover damage added based on aerials and photo.
6659e0299-da6c-448b-8c8a-04e4ac4b842b26.170612-81.690661Daniel Smith9/12/2017HurricaneCMMI-1761461NaN086359d1-022a-4e6e-890c-986b4df55b73,366e794d-ebd1-40a9-820e-5a4114babf91,https://web.fulcrumapp.com/photos/view?photos=086359d1-022a-4e6e-890c-986b4df55b73%2C366e794d-ebd1-40a9-820e-5a4114babf911415732nd Ave SWNaNNaplesCollierFL34116.0US4157 32nd Ave SW Naples Collier FL 34116 USSingle Family ResidenceNaN1992.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2.0yes20%0%0%0%0%0%0%0%NaNNaNNaNRobyn Manhard2aAdded address and adjusted coordinates. Changed surveyor name to Daniel Smith. Added overall building condition. Survey date corrected. Up to 20% roof cover may be damaged based on aerials and photo.
7c320ab17-f8f5-4ef5-a232-c65d1c9445d626.170614-81.691139Daniel Smith9/12/2017HurricaneCMMI-1761461NaNb808536a-5c5b-46da-abd7-ceac20ff2d76NaNhttps://web.fulcrumapp.com/photos/view?photos=b808536a-5c5b-46da-abd7-ceac20ff2d761418532nd Ave SWNaNNaplesCollierFL34116.0US4185 32nd Ave SW Naples Collier FL 34116 USSingle Family ResidenceNaN1980.0NaN1.0GableNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNUnknownNaNNaNUnknownNaNNaNNaNNoneNaNNaNNaNNaNNaNWindNaN1.0yes10%0%0%0%0%0%0%0%NaNNaNNaNRobyn Manhard2aAdded building address and adjusted coordinates. Changed surveyor name to Daniel Smith. Added overall building condition. Survey date corrected. Address verified. Damage ratio added based on photo alone.
877814e2b-ce3b-4660-b433-c08a9a87cf8a26.170559-81.692123Daniel Smith9/12/2017HurricaneCMMI-1761461NaNe106279c-d2e8-4d45-b78b-996ad2d2debb,c4af2b35-6db2-46f7-89c0-96f5cd9e0cb9,https://web.fulcrumapp.com/photos/view?photos=e106279c-d2e8-4d45-b78b-996ad2d2debb%2Cc4af2b35-6db2-46f7-89c0-96f5cd9e0cb91424332nd Ave SWNaNNaplesCollierFL34116.0US4243 32nd Ave SW Naples Collier FL 34116 USSingle Family ResidenceNaN1995.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNUnknownNaNNaNUnknownNaNNaNNaNShuttersNaNyesNaNNoNaNWindNaNNaNyes10%0%0%0%0%0%0%0%NaNNaNyesRobyn Manhard2aAddress updated and coordinates adjusted. Surveyor name changed to Daniel \nSmith. Overall building condition added. Survey date corrected. Aerial image added. Damage ratios added.
9bd1d2906-d0e1-494a-9fa1-c5e1c72eb9fd26.170528-81.692866Daniel Smith9/12/2017HurricaneCMMI-1761461NaNf203eef1-98b7-4759-b95a-db0c2b878721,7d5d536b-d980-42e8-b211-5d9d0923983e,https://web.fulcrumapp.com/photos/view?photos=f203eef1-98b7-4759-b95a-db0c2b878721%2C7d5d536b-d980-42e8-b211-5d9d0923983e1428532nd Ave SWNaNNaplesCollierFL34116.0US4285 32nd Ave SW Naples Collier FL 34116 USSingle Family ResidenceNaN1984.0NaN1.0HipNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNUnknownNaNNaNUnknownNaNUnknownNaNPlywood/OSBNaNyesNaNNoNaNWindNaNNaNNaN10%0%0%0%0%0%0%0%NaNNaNNaNRobyn Manhard2aAdded address and updated coordinates. Survey date corrected. Overall building condition added. Surveyor name changed to Daniel Smith. Roof cover damage updated. Aerial image attached.

Last rows

fulcrum_idlatitudelongitudename_of_surveyordate_of_surveytype_of_disaster_projectgeneral_notesphotosphotos_captionphotos_urloverall_building_conditionbuilding_address_sub_thoroughfarebuilding_address_thoroughfarebuilding_address_suitebuilding_address_localitybuilding_address_sub_admin_areabuilding_address_admin_areabuilding_address_postal_codebuilding_address_countrybuilding_address_fullassessment_typeassessment_type_otheryear_builteffective_year_builtnumber_of_storiesroof_shaperoof_shape_otherroof_coverroof_cover_otherwall_claddingwall_cladding_otherfirst_floor_elevation_ftother_detailsstructural_framing_systemstructural_framing_system_otherroof_sheathing_nail_spacingroof_sheathing_nail_sizeroof_sheathing_nail_size_otherroof_to_wall_connectionroof_to_wall_connection_otheropening_protectionopening_protection_othergarage_doorgarage_door_locationgarage_door_failureother_structural_detailsdamage_modesdamage_modes_othernumber_of_sides_useddamage_visible_in_photosroof_cover_dmgroof_sheathing_dmgroof_structure_dmgwall_cover_dmgwall_sheathing_dmgwall_structure_dmgwindows_dmgdoors_dmgdamage_descriptionwater_height_inchesstructure_usableqc_idqc_codeqc_notes
111162f3e8a8-6021-4587-a3ff-58b84578b7cc26.157039-81.738220Glenn Overcash12/15/2017HurricaneCMMI-1761461New unit installed in November 2017 with tag and wall anchors at ~3?€? on center.8cfe18d5-bf88-4408-80e3-ded44b195a95,292c3dbb-954c-43ba-872f-47d66cb69ea5,https://web.fulcrumapp.com/photos/view?photos=8cfe18d5-bf88-4408-80e3-ded44b195a95%2C292c3dbb-954c-43ba-872f-47d66cb69ea5125Blue Skys DrNaNNaplesCollierFL34104.0US25 Blue Skys Dr Naples Collier FL 34104 USMobile HomeNaN2017.02017.01.0GableNaNAsphalt shingles (3-tab)NaNVinyl sidingNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNnoNaNNaNNaNNaNNaN2.0yes10%0%0%0%0%0%0%0%NaNNaNyesCourtney Hodges2aCoordinates adjusted. Aerial photo added. Year built/effective year built and roof cover dmg added.
111242932818-9c1a-4fb2-9365-cf16fa75420e26.156314-81.736208Glenn Overcash12/15/2017HurricaneCMMI-1761461Lanai destroyed creating openings for rain infiltration. Front end Carport also destroyed.28dcb588-58e5-4075-8696-207b63a6769fNaNhttps://web.fulcrumapp.com/photos/view?photos=28dcb588-58e5-4075-8696-207b63a6769f1163Sand DrNaNNaplesCollierFL34104.0US163 Sand Dr Naples Collier FL 34104 USMobile HomeNaN1983.01983.01.0GableNaNCorrugated metalNaNVinyl sidingNaN0.0NaNNaNNaNNaNUnknownNaNUnknownNaNNaNNaNnoNaNNaNNaNWindNaN1.0yes10%0%0%10%0%0%0%0%NaNNaNyesCourtney Hodges2aCoordinates adjusted. Year built/effective year built, roof cover type, wall cladding type, roof cover dmg, roof sheathing dmg, and roof structure dmg added.
1113c9a80f9e-85e9-4b23-9ca9-e36bf9b91c8426.155958-81.736744Glenn Overcash12/15/2017HurricaneCMMI-1761461Roof damage; lost lanai, carportdbe59fe4-8cce-4c20-9828-7e3f5f0495a6NaNhttps://web.fulcrumapp.com/photos/view?photos=dbe59fe4-8cce-4c20-9828-7e3f5f0495a61118Kim DrNaNNaplesCollierFL34104.0US118 Kim Dr Naples Collier FL 34104 USMobile HomeNaN1978.01978.01.0GableNaNCorrugated metalNaNVinyl sidingNaN0.0NaNWood-frameNaNNaNUnknownNaNUnknownNaNNoneNaNnoNaNNaNNaNWindNaN2.0yes10%0%0%0%0%0%0%0%NaNNaNyesCourtney Hodges; David Roueche2aLocation adjusted; address updated; overall damage changed from severe to minor due to majority of damage being experienced by appurtenant structure (carport).
1114e48b4320-1bc5-49d3-a73e-c05d02667a9c26.109616-81.728765Glenn Overcash12/15/2017HurricaneCMMI-1761461November 2017 installation. Anchorage same as Blue Sky site. No attachments1b55b013-ae35-42a3-8717-a2eee08d0b39,08c4adbc-7ff7-4617-97ed-be19e47f6808,https://web.fulcrumapp.com/photos/view?photos=1b55b013-ae35-42a3-8717-a2eee08d0b39%2C08c4adbc-7ff7-4617-97ed-be19e47f6808031Apple Tree LnNaNNaplesCollierFL34112.0US31 Apple Tree Ln Naples Collier FL 34112 USMobile HomeNaN2018.0NaN1.0GableNaNNaNNaNNaNNaN0.0NaNWood-frameNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0%0%0%0%0%0%0%0%NaNNaNNaNDavid Roueche2bHome was installed post-hurricane. Should not be used in analysis.
111516ef20cf-4d8d-4ba8-84e5-1fd8ede3a9ff26.109649-81.728325Glenn Overcash12/15/2017HurricaneCMMI-1761461New unit - per management: window damaged only. Note carport attachment: engineered to break away3f747db5-981d-4f10-82e3-e3477ae848e5,b1825231-19c3-4194-a2fe-c14043fc1027,https://web.fulcrumapp.com/photos/view?photos=3f747db5-981d-4f10-82e3-e3477ae848e5%2Cb1825231-19c3-4194-a2fe-c14043fc1027125Apple Tree LnNaNNaplesCollierFL34112.0US25 Apple Tree Ln Naples Collier FL 34112 USMobile HomeNaN2017.02017.01.0GableNaNAsphalt shingles (3-tab)NaNVinyl sidingNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN2.0yes10%0%0%0%0%0%0%0%NaNNaNyesCourtney Hodges2aCoordinates adjusted. Aerial photo added. Year built/effective year built and roof cover dmg added.
11164601bd28-82a7-483e-9e75-b32af1ef1a7226.109866-81.728480Glenn Overcash12/15/2017HurricaneCMMI-1761461Carport destroyed - renter unaware of any water damaged5bebfa2-0454-429c-8261-1cbd12d2b673,97fc0d3e-a11c-4444-aa72-d6924e9d6135,https://web.fulcrumapp.com/photos/view?photos=d5bebfa2-0454-429c-8261-1cbd12d2b673%2C97fc0d3e-a11c-4444-aa72-d6924e9d6135126Apple Tree LnNaNNaplesCollierFL34112.0US26 Apple Tree Ln Naples Collier FL 34112 USMobile HomeNaNNaNNaN1.0GableNaNCorrugated metalNaNSheet metalNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNnoNaNNaNNaNNaNNaN1.0yes10%0%0%0%0%0%0%0%NaNNaNyesCourtney Hodges2aCoordinates adjusted. Aerial photo added. Roof cover, wall cladding, and roof cover dmg added. No year built available for specific unit. Minor damage to roof cover. Detached porch structure destroyed.
11175cf87ff9-6e75-45e4-b5d4-268e3ba3b7ac25.923520-81.644078Glenn Overcash12/15/2017HurricaneCMMI-1761461Next door to cover 505 coconut avec2562355-dba3-4a4a-a015-d700cec49b8eNaNhttps://web.fulcrumapp.com/photos/view?photos=c2562355-dba3-4a4a-a015-d700cec49b8e4507Coconut AveNaNGoodlandCollierFL34140.0NaN507 Coconut Ave Goodland Collier FL 34140Mobile HomeNaN1972.0NaN1.0GableNaNCorrugated metalNaNSheet metalNaN0.0NaNWood-frameNaNNaNUnknownNaNNaNNaNNoneNaNnoNaNNaNNaNWindNaNNaNNaN100%100%100%100%100%100%100%100%Possible surge damage as well.NaNNaNDavid Roueche2aNaN
11185d3a9fd5-d5b6-4581-865d-283f570d653025.923993-81.643508Glenn Overcash12/15/2017HurricaneCMMI-1761461Roof Structure gone above carport.f1587d6c-59d4-40b2-8906-bb5edd774296,7650d8ff-eee5-48b4-942e-18891aec2d57,https://web.fulcrumapp.com/photos/view?photos=f1587d6c-59d4-40b2-8906-bb5edd774296%2C7650d8ff-eee5-48b4-942e-18891aec2d574505Coconut AvenueNaNGoodlandCollierFL34140.0NaN505 Coconut Avenue Goodland Collier FL 34140Single Family ResidenceNaN1980.01980.02.0ComplexNaNAsphalt shingles (3-tab)NaNStuccoNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNnoNaNNaNNaNNaNNaN1.0yes30%30%30%0%0%0%0%0%NaNNaNnoCourtney Hodges2aCoordinates adjusted. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, roof sheathing dmg, and roof structure dmg added.
111997d59c95-0910-48da-8b35-e45fe75bed6d25.925105-81.648313Glenn Overcash12/15/2017HurricaneCMMI-1761461Metal roof damaged88878432-6681-4f07-bed1-290e4dee20dc,f5c364f7-6e54-42e0-9cc6-a532546afda4,https://web.fulcrumapp.com/photos/view?photos=88878432-6681-4f07-bed1-290e4dee20dc%2Cf5c364f7-6e54-42e0-9cc6-a532546afda42505W Goodland DrNaNGoodlandCollierFL34140.0NaN505 W Goodland Dr Goodland Collier FL 34140Single Family ResidenceNaN1967.01967.01.0ComplexNaNCorrugated metalNaNVinyl sidingNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNnoNaNNaNNaNNaNNaN1.0no10%10%0%0%0%0%0%0%NaNNaNyesCourtney Hodges2aCoordinates adjusted. Address updated. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, and roof sheathing dmg added.
11202f7e30a8-ccbb-4783-b96d-71798c3d8da326.046961-81.661047Glenn Overcash12/15/2017HurricaneCMMI-1761461Carport lost, gable end wall breached1888a9c2-1fab-4558-824a-2fdb4ca21387,5d341cf5-86a7-4455-ad38-d7965e92f48f,https://web.fulcrumapp.com/photos/view?photos=1888a9c2-1fab-4558-824a-2fdb4ca21387%2C5d341cf5-86a7-4455-ad38-d7965e92f48f3211Ocean Reef LnNaNNaplesCollierFL34114.0US211 Ocean Reef Ln Naples Collier FL 34114 USMobile HomeNaN1983.01983.01.0GableNaNCorrugated metalNaNVinyl sidingNaN0.0NaNNaNNaNNaNUnknownNaNNaNNaNNaNNaNnoNaNNaNNaNWindNaN2.0yes20%10%0%10%10%0%0%0%NaNNaNnoCourtney Hodges2aCoordinates adjusted. Aerial photo added. Year built/effective year built, roof shape, roof cover, wall cladding, roof cover dmg, roof sheathing dmg, wall cover dmg, and wall sheathing dmg added.